Displays a variety of Sybase IQ status information about the current database.
sp_iqstatus
Shows status information about the current database, including the database name, creation date, page size, number of dbspace segments, block usage, buffer usage, I/O, backup information, and so on. On a query server in a multiplex, this procedure lists information about the IQ Local Store as well as the shared IQ Store and IQ Temporary Store.
If sp_iqstatus shows a high percentage of main blocks in use on a multiplex server, run sp_iqversionuse to find out which versions are being used and the amount of space that can be recovered by releasing versions. See “sp_iqversionuse procedure”.
The system stored procedure sp_iqspaceused returns a subset of the same information as that provided by sp_iqstatus, but allows the user to return the information in SQL variables to be used in calculations. See “sp_iqspaceused procedure”.
The following output is from the sp_iqstatus stored procedure:
Adaptive Server IQ (TM) Copyright (c) 1992-2006 by Sybase, Inc. All rights reserved. Version: 12.7.0/040810/P/GA/MS/ Windows 2000/32bit/2006-06-10 09:54:19 Time Now: 2006-06-11 18:53:34.274 Build Time: 2006-06-10 09:54:19 File Format: 23 on 03/18/1999 Server mode: IQ Server Catalog Format: 2 Stored Procedure Revision: 1 Page Size: 131072/8192blksz/16bpp Number of DB Spaces: 1 Number of Temp Spaces: 1 DB Blocks: 1-5632 IQ_SYSTEM_MAIN Temp Blocks: 1-2816 IQ_SYSTEM_TEMP Create Time: 2006-06-03 14:14:06.124 Update Time: 2006-06-03 14:14:26.687 Main IQ Buffers: 127, 16Mb Temporary IQ Buffers: 95, 12Mb Main IQ Blocks Used: 4541 of 5632, 80%=35Mb, Max Block#: 5120 Temporary IQ Blocks Used: 65 of 2816, 2%=0Mb, Max Block#: 0 Main Reserved Blocks Available: 512 of 512, 100%=4Mb Temporary Reserved Blocks Available: 256 of 256, 100%=2Mb IQ Dynamic Memory: Current: 41mb, Max: 41mb Main IQ Buffers: Used: 4, Locked: 0 Temporary IQ Buffers: Used: 4, Locked: 0 Main IQ I/O: I: L168/P2 O: C2/D16/P15 D:0 C:100.0 Temporary IQ I/O: I: L862/P0 O: C136/D150/P17 D:132 C:100.0 Other Versions: 0 = 0Mb Active Txn Versions: 0 = C:0Mb/D:0Mb
The following is a key to understanding the Main
IQ I/O and Temporary IQ
I/O output codes:
I: Input
L: Logical
pages read (“Finds”)
P: Physical
pages read
O: Output
C Pages
Created
D Pages
Dirtied
P: Physically
Written
D: Pages
Destroyed
C: Compression
Ratio
