System Procedures

Certain system procedures have special syntax or usage notes to support multiplex functionality.

• sp_iqcheckdb Procedure
  Checks validity of the current database. Optionally corrects allocation problems for dbspaces or databases. sp_iqcheckdb does not check a partitioned table if partitioned data exists on offline dbspaces.
• sp_iqconnection Procedure
  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.
• sp_iqdbsize Procedure
  Displays the size of the current database.
• sp_iqdbspace Procedure
  Displays detailed information about each SAP Sybase IQ dbspace.
• sp_iqdbspaceinfo Procedure
  Displays the size of each object and subobject used in the specified table. Not supported for RLV dbspaces.
• sp_iqfile Procedure
  Displays detailed information about each dbfile in a dbspace.
• sp_iqindexinfo Procedure
  Displays the number of blocks used per index per main dbspace for a given object. If the object resides on several dbspaces, sp_iqindexinfo returns the space used in all dbspaces, as shown in the example.
• sp_iqmpxcheckdqpconfig Procedure
  sp_iqmpxcheckdqpconfig is a diagnostic tool that checks the DQP configuration for the current connection. If DQP fails, run sp_iqmpxcheckdqpconfig to determine if DQP configuration issues are causing the query distribution failure.
• sp_iqmpxdumptlvlog Procedure
  Returns the contents of the table version log in a readable format.
• sp_iqmpxfilestatus Procedure
  If run on the coordinator node, displays file status for coordinator and for every shared dbspace file on every included secondary node. If executed on a secondary node, displays file status for only the current node.
• sp_iqmpxincconnpoolinfo Procedure
  If run on the coordinator node, displays INC connection pool status for every node. If executed on a secondary node, displays INC connection pool status for only the current node.
• sp_iqmpxincheartbeatinfo Procedure
  If run on the coordinator node, displays INC heartbeat status for every node. If executed on a secondary node, displays INC heartbeat status for just the current node.
• sp_iqmpxincstatistics Procedure
  Displays a snapshot of the aggregate statistics of internode communication (INC) status since server startup as of the moment of execution.
• sp_iqmpxinfo Procedure
  Returns a row for every node in the multiplex. Can be run from any multiplex node.
• sp_iqmpxsuspendedconninfo Procedure
  Shows details about currently suspended connections and transactions on the coordinator node.
• sp_iqmpxvalidate Procedure
  Checks multiplex configuration for inconsistencies.
• sp_iqmpxversioninfo Procedure
  Shows the current version information for this server, including server type (write server, query server, single-node mode) and synchronization status.
• sp_iqsharedtempdistrib Procedure
  Shows the current shared temp space usage distribution. If run from the coordinator, sp_iqsharedtempdistrib displays shared temp space distribution for all nodes. If run from a secondary node, displays shared temp space usage for only that node.
• sp_iqspaceinfo Procedure
  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.
• sp_iqspaceused Procedure
  Shows information about space available and space used in the IQ store, IQ temporary store, RLV store, and IQ global and local shared temporary stores.
• sp_iqstatus Procedure
  Displays a variety of SAP Sybase IQ status information about the current database.
• sp_iqtransaction Procedure
  Shows information about transactions and versions.
• sp_iqversionuse Procedure
  Displays version usage for the IQ main store.