Filter
Top Products
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
=======================================================
===================
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