sp_iqstatus procedure

Function

Displays a variety of Sybase IQ status information about the current database.

Syntax

sp_iqstatus 

Description

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”.

Example

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: