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.

• sa_char_terms System Procedure
  Breaks a CHAR string into terms and returns each term as a row along with its position.
• sa_dependent_views Procedure
  Returns the list of all dependent views for a given table or view.
• sa_external_library_unload Procedure
  Unloads an external library.
• sa_list_external_library Procedure
  Lists the external libraries currently loaded in the server.
• sa_nchar_terms system Procedure
  Breaks an NCHAR string into terms and returns each term as a row along with its position.
• sa_text_index_vocab Procedure
  Lists all terms that appear in a TEXT index, and the total number of indexed values that each term appears in.
• sa_verify_password Procedure
  Validates the password of the current user.
• sa_get_user_status Procedure
  Allows you to determine the current status of users.
• sp_expireallpasswords Procedure
  Causes all user passwords to expire immediately.
• sp_iqaddlogin Procedure
  Adds a new 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
  Helps you generate indexes by analyzing the cardinality of the columns in the table and recommending the indexes to add.
• sp_iqcheckdb Procedure
  Checks validity of the current database. Optionally corrects allocation problems for dbspaces or databases.
• 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 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_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 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 or join index.
• sp_iqdbspaceobjectinfo Procedure
  Lists objects of type table and join index and their sub-objects (columns, indexes, metadata, primary keys, unique constraints, foreign keys, and partitions) for a given dbspace.
• sp_iqdbstatistics Procedure
  Reports results of the most recent sp_iqcheckdb.
• sp_iqdroplogin Procedure
  Drops a 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.
• sp_iqestjoin Procedure
  Estimates the space needed to create join indexes for the tables you specify.
• 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 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_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_iqjoinindex Procedure
  Displays information about join indexes.
• sp_iqjoinindexsize Procedure
  Gives the size of the specified join index.
• 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 store and the catalog store.
• sp_iqmodifyadmin Procedure
  Sets an option on a named login policy to a certain value. If no login policy is specified, the option is set on the root policy. In a multiplex, sp_iqmodifyadmin takes an optional parameter that is the multiplex server name.
• sp_iqmodifylogin Procedure
  Assigns a user to a login policy.
• sp_iqmpxfilestatus procedure
  When executed on the coordinator node, displays file status for every shared dbfile on every included secondary 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 just 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_iqmpxinfo Procedure
  If run on the coordinator node, displays complete multiplex configuration info for all nodes. If run on a secondary node, displays complete multiplex configuration info for only that node.
• sp_iqmpxvalidate Procedure
  Checks multiplex configuration for inconsistencies.
• sp_iqmpxversioninfo Procedure
  Shows the current version information for this server.
• sp_iqobjectinfo Procedure
  Returns partitions and dbspace assignments of database objects and sub-objects.
• 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 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 one or more indexes on a table with the original IQ UNIQUE value specified in the CREATE TABLE statement, or a new IQ UNIQUE value to change storage required and/or query performance.
• 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_iqrowdensity Procedure
  Reports information about the internal row fragmentation for a table at the FP index level.
• sp_iqsharedtempdistrib procedure
  Returns diagnostic information about how shared temp space is distributed among nodes of the multiplex and whether that space is usable or quarantined.
• 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, 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 Sybase IQ status information about the current database.
• sp_iqsysmon Procedure
  Monitors multiple components of 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 only for queries (SQL statements containing a FROM clause). You cannot use sp_iqworkmon for INSERT or LOAD statements.