Sybase IQ offers several stored procedures that display information about your database:
sp_iqconnection displays statistics about user connections and versions
sp_iqcontext displays information about what statements are executing
sp_iqcheckdb checks the validity of your current database
sp_iqdbstatistics reports results of the most recent sp_iqcheckdb
sp_iqdbsize gives the size of the current database
sp_iqspaceinfo displays space usage by each object in the database
sp_iqstatus displays miscellaneous status information about the database.
sp_iqtablesize gives the size of the table you specify.
sp_iqgroupsize lists the members of the specified group.
See Reference: Building Blocks, Tables, and Procedures for syntax details and examples of all Sybase IQ stored procedures.
