Filter
Top Products
CHAPTER 3 Working with Database Objects
117
Name Value
=======================================================
Adaptive Server IQ (TM) Copyright (c) 1992-2000 by Sybase, Inc. All rights
reserved.
Version: 12.4.2/(32bit mode)/Sun_svr4/OS 5.6/EBF 0000
Time Now: 2000-03-14 12:05:54.288
Build Time: Sat Mar 11, 2000 21:39:55 EST
File Format: 23 on 03/18/1999
Catalog Format: 2
Stored Procedure Revision: 1
Page Size: 131072/8192blksz/16bpp
Number of DB Spaces: 8
Number of Temp Spaces: 2
DB Blocks: 1-12132344 IQ_SYSTEM_MAIN
DB Blocks: 12545280-24677623 mydb_2
DB Blocks: 25090560-37222903 mydb_3
DB Blocks: 37635840-49768183 mydb_4
DB Blocks: 50181120-62313463 mydb_5
DB Blocks: 62726400-74858743 mydb_6
DB Blocks: 75271680-87404023 mydb_7
DB Blocks: 87816960-99949303 mydb_8
Temp Blocks: 1-8823288 IQ_SYSTEM_TEMP
Temp Blocks: 9408960-18232247 mydb_tmp2
Create Time: 1999-12-30 19:10:55.231
Update Time: 2000-03-14 09:52:13.609
Main IQ Buffers: 11174, 1400Mb
Temporary IQ Buffers: 15165, 1900Mb
Main IQ Blocks Used: 43515029 of 97058752, 44%=331Gb, Max
Block#: 95065709
Temporary IQ Blocks Used: 610 of 17646576, 0%=4Mb, Max Block#: 0
Main Reserved Blocks Available: 1280 of 1280, 100%=10Mb
Temporary Reserved Blocks Available: 1280 of 1280, 100%=10Mb
Memory: Current: 3351mb, Max: 3384mb
Main IQ Buffers: Used: 11172, Locked: 0
Temporary IQ Buffers: Used: 38, Locked: 0
Main IQ I/O: I: L88043944/P495510 O:
C760342/D761393/P736587 D:24753 C:65.9
Temporary IQ I/O: I: L16515025/P1222153 O:
C2609951/D3838862/P1228941
D:2609913 C:46.3
Old Versions: 1 = 59Gb
Active Txn Versions: 0 = C:0Mb/D:0Mb