Sybase 12.4.2 User Manual

Page 486

Viewing the Adaptive Server IQ environment

466

•

sp_iqcheckdb

checks the validity of your current database

•

sp_iqdbstatistics

reports results of the most recent sp_iqcheckdb

•

sp_iqdbsize

gives the size of the current database

•

sp_iqstatus

displays miscellaneous status information about the database.

See the example below.

•

sp_iqtablesize

gives the size of the table you specify.

•

sp_iqgroupsize

lists the members of the specified group.

See Adaptive Server IQ Reference Manual for details of all Adaptive Server IQ
stored procedures.

Example

The output from

sp_iqstatus

looks like the following:

Name Value

=======================================================
===================

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