Sybase IQ stored procedures

The following procedures work specifically on the IQ Store. They are owned by the DBA user ID.

Stored procedures that produce size information assume that the database was created with the default block size, as described in “Block size” in Sybase IQ Performance and Tuning Guide. If a database was created with a non-default block size, the output from the following stored procedures is inaccurate: sp_iqestjoin, sp_iqestdbspaces, sp_iqestspace.

**Table 1-2: Stored Procedures for the IQ Store**
Procedure name	Purpose
sp_iqaddlogin	Adds a new Sybase IQ user account, and specifies the number of current logins the user may have and the password expiration interval
sp_iqcheckdb	Checks the validity of the current database and repairs indexes
sp_iqcolumn	Displays columns in a database and information about them
sp_iqconnection	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, and database version status
sp_iqconstraint	Lists referential integrity constraints for the specified table or column
sp_iqcontext	Displays the currently executing statement for each active connection, or for a single connection
sp_iqcursorinfo	Displays detailed information about cursors currently open on the server
sp_iqdatatype	Displays information about system data types and user-defined data types
sp_iqdbsize	Gives the size of the current database
sp_iqdbspace	Lists detailed information including usage, properties, and types of data on each dbspace.
sp_iqdbspaceinfo	Displays the number of blocks user per index per main or local dbspace for one or all dbspaces.
sp_iqdbstatistics	Reports results of the most recent sp_iqcheckdb
sp_iqdroplogin	Drops an IQ login
sp_iqestjoin	Estimates the space needed to create join indexes for the tables you specify
sp_iqestdbspaces	Estimates the number and size of dbspaces needed for a given total index size
sp_iqestspace	Estimates the amount of space needed to create a database, based on the number of rows in the underlying database tables
sp_iqevent	Displays information about system and user-defined events
sp_iqhelp	Displays information about system and user-defined objects and data types
sp_iqindex	Lists indexes and information about them. Omitting the parameter lists all indexes in the database. Specifying the table_name parameter lists indexes for this table only.
sp_iqindexinfo	Displays the number of blocks user per index per main or local dbspace for a given object.
sp_iqindex_alt	Same as sp_iqindex, except that for multicolumn indexes it lists one row for each column.
sp_iqindexsize	Gives the size of the specified index
sp_iqjoinindex	Displays information about join indexes
sp_iqjoinindexsize	Gives the size of the specified join index
sp_iqlistexpiredpass words	Lists user accounts with expired passwords
sp_iqlistlockedusers	Lists locked user accounts
sp_iqlistpasswordexpira tions	Lists user accounts, their password creation dates, and number of days password is valid from creation date
sp_iqlocklogin	Locks an IQ user account so that the user cannot log in
sp_iqlocks	Shows information about locks in the IQ Store and the Catalog Store
sp_iqmodifyadmin	Enables or disables Sybase IQ User Administration, and sets defaults for user account characteristics in the IQ_SYSTEM_LOGIN_INFO_TABLE system table
sp_iqmodifylogin	Modifies the maximum number of connections or the password expiration interval for a single user or all users
sp_iqpassword	Adds or changes a password for an IQ login account
sp_iqpkeys	Displays information about primary keys and primary key constraints by table, column, table owner, or for all IQ tables in the database
sp_iqprocedure	Displays information about system and user-defined procedures
sp_iqprocparm	Displays information about stored procedure parameters, including result set variables and SQLSTATE/SQLCODE error values
sp_iq_process_login	When the LOGIN_PROCEDURE database option is set to sp_iq_process_login, determines which users can log on
sp_iqrelocate	Relocates specified tables and indexes on main dbspaces in relocate mode to main or local dbspaces in readwrite mode.
sp_iqrename	Renames user-created tables, views, columns, indexes, constraints (unique, primary key, foreign key, and check), stored procedures, and functions
sp_iqshowpsexe	Displays information about the settings of database options that control the priority of tasks and resource usage for connections
sp_iqspaceinfo	Lists the number of blocks used per object per dbspace.
sp_iqspaceused	Shows information about space available and space used in IQ Store and IQ Temporary Store
sp_iqstatus	Displays a variety of IQ status information about the database
sp_iqsysmon	Monitors multiple components of Sybase IQ, including the management of buffer cache, memory, threads, locks, I/O functions, and CPU utilization
sp_iqtable	Lists tables and information about them. Omitting the parameter lists all tables in the database. Specifying the table_name parameter lists columns for this table only.
sp_iqtablesize	Gives the size of the specified table
sp_iqtransaction	Shows information about transactions and versions
sp_iqview	Displays views in a database and information about them
sp_iqwho	Displays information about all current users and connections or about a particular user or connection