Getting Information Using Stored Procedures

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 Sybase IQ, connection status, database version status, and so on.

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.

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.

See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqcheckdb procedure

sp_iqdbstatistics

Reports results of the most recent sp_iqcheckdb.

See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqdbstatistics procedure

sp_iqdbsize

Displays the size of the current database.

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

See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqspaceinfo procedure

sp_iqstatus

Displays miscellaneous status information about the database.

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.

See Building Blocks, Tables, and Procedures > System Procedures > System stored procedures > sp_iqtablesize procedure