Listing 3: Database space report
***************************************************************** ***************************************************************** DATE: 09/09/96 TIME: 04:00:01 System databases are excluded from this report: master model pubs2 sybsecurity sybsystemprocs tempdb ***************************************************************** ***************************************************************** ***************************************************************** UNIX Server: dspu004 ***************************************************************** name db_size owner dbid created status ----- --------- ------ ----- ------------ ------------------- pay01 3410.0 MB lawson 5 Jul 23, 1996 select into/bulkcopy device_fragments size usage free kbytes ------------------------- ------------- --------------- ----------- pay01_disk01 975.0 MB data only 480 pay01_disk02 975.0 MB data only 144 pay01_disk03 975.0 MB data only 998400 pay01_log01 485.0 MB log only 496608 (1 row affected) device segment ------------------------------ pay01_disk01 default pay01_disk01 pay01_seg01 pay01_disk01 system pay01_disk02 pay01_seg02 pay01_disk03 default pay01_disk03 pay01_seg01 pay01_disk03 system pay01_log01 logsegment name db_size owner dbid created status ------ ------- ----- ---- ------------ --------------------- workdb 570.0 MB sa 6 Aug 21, 1996 select into/bulkcopy device_fragments size usage free kbytes ------------------------- ------------- --------------- ----------- workdb_disk01 500.0 MB data only 511328 workdb_log01 70.0 MB log only 71664 (1 row affected) device segment ------------------------------ workdb_disk01 default workdb_disk01 system workdb_log01 logsegment ********************************************************* UNIX Server: dspu003 ********************************************************* name db_size owner dbid created status ---- -------- ----- ---- ----------- ---------------------- MIDB 250.0 MB sa 6 May 04, 1995 no options set device_fragments size usage free kbytes ------------------------- ------------- --------------- ----------- pmidat01 200.0 MB data only 199872 pmilog01 50.0 MB log only 51184 device segment ------------------------------ pmidat01 default pmidat01 system pmilog01 logsegment End of Report
|