Stored procedures that return database usage statistics.
Name |
Description |
---|---|
sp_iqconnection |
Shows information about connections and versions, including which
users are using temporary dbspace, which users are keeping
versions alive, what the connections are doing inside
SAP Sybase IQ, connection status,
database version status, and so on.
Usage:
sp_iqconnection [ connhandle ] See Reference: Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqconnection procedure |
sp_iqcontext |
Tracks and displays, by connection, information about statements
that are currently executing.
Usage:
sp_iqcontext [ connhandle ] See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqcontext procedure |
sp_iqcheckdb |
Checks validity of the current database. Optionally corrects
allocation problems for dbspaces or databases.
Usage:
sp_iqcheckdb 'mode target [ … ] [ resources resource-percent ]' See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqcheckdb procedure |
sp_iqdbstatistics |
Reports results of the most recent
sp_iqcheckdb.
Usage:
sp_iqdbstatistics See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqdbstatistics procedure |
sp_iqdbsize |
Displays the size of the current database.
Usage:
sp_iqdbsize([ main ] ) See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqdbsize procedure |
sp_iqspaceinfo |
Displays space usage by each object in the database.
Usage:
sp_iqspaceinfo [‘main | [table table-name | index index-name] [...] ‘] See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqspaceinfo procedure |
sp_iqstatus |
Displays miscellaneous status information about the database.
Usage:
sp_iqstatus See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqstatus procedure |
sp_iqtablesize |
Displays the number of blocks used by each object in the current
database and the name of the dbspace in which the object is
located.
Usage:
sp_iqtablesize ( table_owner.table_name ) See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqtablesize procedure |