Sybase IQ provides numerous stored procedures for viewing and managing information. For example, sp_iqstatus displays general status information, while sp_iqcheckdb checks the validity of the current database and can repair allocation problems.
See Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures for details on the IQ stored procedures.
Several multiplex stored procedures are also available. See Using Sybase IQ Multiplex for more information.