Sybase 12.4.2 User Manual

Page 137

Advertising
background image

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

Advertising