The document shows the configuration of a Sybase database instance. It lists the directory structure and files for a Sybase installation. It then runs a batch file that sets various environment variables needed to run the Sybase software. Finally, it performs some commands in isql to view database information and resize the transaction log volume.
The document shows the configuration of a Sybase database instance. It lists the directory structure and files for a Sybase installation. It then runs a batch file that sets various environment variables needed to run the Sybase software. Finally, it performs some commands in isql to view database information and resize the transaction log volume.
The document shows the configuration of a Sybase database instance. It lists the directory structure and files for a Sybase installation. It then runs a batch file that sets various environment variables needed to run the Sybase software. Finally, it performs some commands in isql to view database information and resize the transaction log volume.
The document shows the configuration of a Sybase database instance. It lists the directory structure and files for a Sybase installation. It then runs a batch file that sets various environment variables needed to run the Sybase software. Finally, it performs some commands in isql to view database information and resize the transaction log volume.
----------------------------------------------------------------------------------- ----------------------------------------------------------------------------------- ----------------------------------------------------------------------------------- ----- SMA 194560.0 MB sapsa 4 Jul 13, 2019 full 100 2000 ddl in tran, allow nulls by default, abort tran on log full, allow db suspect on rollback error, allow wide dol rows, deferred table allocation, page compression, allow incremental dumps, deallocate first text page, index compression,full logging for all
(1 row affected)
device_fragments size usage created free_kbytes
---------------- ------------- --------- ------------------- ---------------- SMA_data_001 92160.0 MB data only Jul 13 2019 11:14AM 32272 SMA_log_001 20480.0 MB log only Jul 13 2019 11:14AM not applicable SMA_data_002 81920.0 MB data only Sep 10 2019 1:33PM 76692000
------ ------------- ------------------- ------ ------- SMA 20480.00 MB Jul 13 2019 11:14AM 0 5898240 (return status = 0) 1> use master 2> go 1> disk resize name='SMA_log_001',size='10g' 2> go 1> alter database SMA log on SMA_log_001='10g' 2> go Extending database by 655360 pages (10240.0 megabytes) on disk SMA_log_001 Processed 256 allocation unit(s) out of 2560 units (allocation page 12517120). 10% completed. Processed 512 allocation unit(s) out of 2560 units (allocation page 12582656). 20% completed. Processed 768 allocation unit(s) out of 2560 units (allocation page 12648192). 30% completed. Processed 1024 allocation unit(s) out of 2560 units (allocation page 12713728). 40% completed. Processed 1280 allocation unit(s) out of 2560 units (allocation page 12779264). 50% completed. Processed 1536 allocation unit(s) out of 2560 units (allocation page 12844800). 60% completed. Processed 1792 allocation unit(s) out of 2560 units (allocation page 12910336). 70% completed. Processed 2048 allocation unit(s) out of 2560 units (allocation page 12975872). 80% completed. Processed 2304 allocation unit(s) out of 2560 units (allocation page 13041408). 90% completed. Processed 2560 allocation unit(s) out of 2560 units (allocation page 13106944). 100% completed. Warning: Using ALTER DATABASE to extend the log segment will cause user thresholds on the log segment within 128 pages of the last chance threshold to be disabled. 1> sp_helpdb SMA 2> go name db_size owner dbid created durability lobcomplvl inrowlen status
----------------------------------------------------------------------------------- ----------------------------------------------------------------------------------- ----------------------------------------------------------------------------------- ----- SMA 204800.0 MB sapsa 4 Jul 13, 2019 full 100 2000 ddl in tran, allow nulls by default, abort tran on log full, allow db suspect on rollback error, allow wide dol rows, deferred table allocation, page compression, allow incremental dumps, deallocate first text page, index compression,full logging for all
(1 row affected)
name attribute_class attribute int_value char_value comments
---- --------------------------- ------------- --------- ---------- -------- SMA Allocation Unit Initializer disk fragment NULL NULL NULL
device_fragments size usage created free_kbytes
---------------- ------------- --------- ------------------- ---------------- SMA_data_001 92160.0 MB data only Jul 13 2019 11:14AM 32272 SMA_log_001 20480.0 MB log only Jul 13 2019 11:14AM not applicable SMA_data_002 81920.0 MB data only Sep 10 2019 1:33PM 76692000 SMA_log_001 10240.0 MB log only Dec 2 2019 12:09PM not applicable
