Alphabetical List of System Stored Procedures

System stored procedures carry out System Administrator tasks in the IQ main store.

System stored procedures are owned by the user ID dbo.

• sp_iqaddlogin Procedure
  Adds a new SAP Sybase IQ user account to the specified login policy.
• sp_iqbackupdetails Procedure
  Shows all the dbfiles included in a particular backup.
• sp_iqbackupsummary Procedure
  Summarizes backup operations performed.
• sp_iqcardinality_analysis Procedure
  Analyzes the cardinality of columns in a table.
• 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_iqcheckoptions Procedure
  For the connected user, sp_iqcheckoptions displays a list of the current value and the default value of database and server startup options that have been changed from the default.
• sp_iqclient_lookup Procedure
  Allows a client application to determine the SAP Sybase IQ user account responsible for a particular data stream, as observed in a network analyzer originating from a specific client IP address/port.
• sp_iqcolumn Procedure
  Displays information about columns in a database.
• sp_iqcolumnmetadata Procedure
  Returns details about column indexes in one or more tables.
• sp_iqcolumnuse Procedure
  Reports detailed usage information for columns accessed by the workload.
• 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_iqconstraint Procedure
  Lists referential integrity constraints defined using CREATE TABLE or ALTER TABLE for the specified table or column.
• sp_iqcontext Procedure
  Tracks and displays, by connection, information about statements that are currently executing.
• sp_iqcopyloginpolicy Procedure
  Creates a new login policy by copying an existing one.
• sp_iqcursorinfo Procedure
  Displays detailed information about cursors currently open on the server.
• sp_iqdatatype Procedure
  Displays information about system data types and user-defined data types.
• sp_iqdbsize Procedure
  Displays the size of the current database.
• sp_iqdbspace Procedure
  Displays detailed information about each IQ dbspace.
• sp_iqdbspaceinfo Procedure
  Displays the size of each object and subobject used in the specified table. Not supported for RLV dbspaces.
• sp_iqdbspaceobjectinfo Procedure
  Lists objects and subobjects of type table (including columns, indexes, metadata, primary keys, unique constraints, foreign keys, and partitions) for a given dbspace. Not supported for RLV dbspaces.
• sp_iqdbstatistics Procedure
  Reports results of the most recent sp_iqcheckdb.
• sp_iqdroplogin Procedure
  Drops an SAP Sybase IQ user account.
• sp_iqemptyfile Procedure
  Empties a dbfile and moves the objects in the dbfile to another available read-write dbfile in the same dbspace. Not available for files in an RLV dbspace.
• sp_iqestdbspaces Procedure
  Estimates the number and size of dbspaces needed for a given total index size.
• sp_iqestspace Procedure
  Estimates the amount of space needed to create an index based on the number of rows in the table.
• sp_iqevent Procedure
  Displays information about system and user-defined events.
• sp_iqfile Procedure
  Displays detailed information about each dbfile in a dbspace.
• sp_iqhelp Procedure
  Displays information about system and user-defined objects and data types.
• sp_iqindex and sp_iqindex_alt Procedures
  Lists information about indexes.
• sp_iqindexadvice Procedure
  Displays stored index advice messages. Optionally clears advice storage.
• sp_iqindexfragmentation Procedure
  Reports information about the percentage of page space taken up within the B-trees, garrays, and bitmap structures in SAP Sybase IQ indexes.
• 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_iqindexmetadata Procedure
  Displays index metadata for a given index.
• sp_iqindexrebuildwidedata Procedure
  Identifies wide columns in migrated databases that you must rebuild before they are available for read/write activities.
• sp_iqindexsize Procedure
  Gives the size of the specified index.
• sp_iqindexuse Procedure
  Reports detailed usage information for secondary (non-FP) indexes accessed by the workload.
• sp_iqlmconfig Procedure
  Controls license management configurations, displays and sets license type and status.
• 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_iqmodifylogin Procedure
  Assigns a user to a login policy.
• 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_iqobjectinfo Procedure
  Returns partitions and dbspace assignments of database objects and subobjects.
• sp_iqpassword Procedure
  Changes a user’s password.
• sp_iqpkeys Procedure
  Displays information about primary keys and primary key constraints by table, column, table owner, or for all SAP Sybase IQ tables in the database.
• sp_iqprocedure Procedure
  Displays information about system and user-defined procedures.
• sp_iqprocparm Procedure
  Displays information about stored procedure parameters, including result set variables and SQLSTATE/SQLCODE error values.
• sp_iqrebuildindex Procedure
  Rebuilds column indexes.
• sp_iqrename Procedure
  Renames user-created tables, columns, indexes, constraints (unique, primary key, foreign key, and check), stored procedures, and functions.
• sp_iq_reset_identity Procedure
  Sets the seed of the Identity/Autoincrement column associated with the specified table to the specified value.
• sp_iqrestoreaction Procedure
  Shows what restore actions are needed to bring database to a consistent state with a given past date.
• sp_iqrlvmemory Procedure
  Monitors RLV store memory usage per table.
• sp_iqrowdensity Procedure
  Reports information about the internal row fragmentation for a table at the FP index level.
• sp_iqsetcompression Procedure
  Sets compression of data in columns of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data types.
• 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_iqshowcompression Procedure
  Displays compression settings for columns of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data types.
• sp_iqshowpsexe Procedure
  Displays information about the settings of database options that control the priority of tasks and resource usage for connections.
• 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_iqtableuse Procedure
  Reports detailed usage information for tables accessed by the workload.
• sp_iqtransaction Procedure
  Shows information about transactions and versions.
• sp_iqunusedcolumn Procedure
  Reports IQ columns that were not referenced by the workload.
• sp_iqunusedindex Procedure
  Reports IQ secondary (non-FP) indexes that were not referenced by the workload.
• sp_iqunusedtable Procedure
  Reports IQ tables that were not referenced by the workload.
• sp_iqversionuse Procedure
  Displays version usage for the IQ main store.
• sp_iqview Procedure
  Displays information about views in a database.
• sp_iqwho Procedure
  Displays information about all current users and connections, or about a particular user or connection.
• sp_iqworkmon Procedure
  Controls collection of workload monitor usage information, and reports monitoring collection status. sp_iqworkmon collects information for all SQL statements.