Procedures

Use the system-supplied stored procedures in SAP Sybase IQ databases to retrieve system information.

• sa_conn_info system procedure
  Reports connection property information.
• sa_report_deadlocks System Procedure
  Retrieves information about deadlocks from an internal buffer created by the database server.
• sa_server_option System Procedure
  Overrides a server option while the server is running..
• sp_iqcolumn Procedure
  Displays information about columns in a database.
• 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 IQ dbspace.
• sp_iqfile Procedure
  Displays detailed information about each dbfile in a dbspace.
• sp_iqlocks Procedure
  Shows information about locks in the database, for both the IQ main store and the IQ catalog store.
• sp_iqmergerlvstore Procedure
  Triggers a merge of the row-level versioned (RLV) store with the IQ main store.
• sp_iqrlvmemory Procedure
  Monitors RLV store memory usage per table.
• 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_iqstatistics Procedure
  Returns serial number, name, description, value, and unit specifier for each available statistic, or a specified statistic.
• sp_iqstatus Procedure
  Displays a variety of SAP Sybase IQ status information about the current database.
• sp_iqsysmon Procedure
  Monitors multiple components of SAP Sybase IQ, including the management of buffer cache, memory, threads, locks, I/O functions, and CPU utilization.
• sp_iqtable Procedure
  Displays information about tables in the database.
• sp_iqtablesize Procedure
  Returns the size of the specified table.
• sp_iqtransaction Procedure
  Shows information about transactions and versions.
• sp_iqwho Procedure
  Displays information about all current users and connections, or about a particular user or connection.