There are many monitoring / status type store procedures in Sybase IQ .. some overlap in functionality a bit, and sometimes it can be difficult to determine what activities are in process. The procedures listed below should provide a good starting point for most troubleshooting situations.
-- List overall detail about the server / space free / versions
sp_iqstatus ;
-- List all connections
sp_iqwho ;
-- List connections and program/application info
sp_iqshowpsexe ;
-- List active transaction / versioning info
sp_iqtransaction ;
-- List last/current SQL call by connection ID
-- Requires -zl parm at startup
sa_conn_activity ;
-- List object allocation info - takes a long time to run for large DBs
sp_iqdbspace ;
-- Database size details - takes a long time to run for large DBs
sp_iqdbsize ;
-- MultiPlex information
sp_iqversionuse ;
|
|