This version of Sybase IQ has several new system stored procedures that facilitate the tasks of the database administrator when gathering information about database objects, renaming objects, and monitoring IQ components, users, connections, and tasks. The new stored procedures are listed in Table 1-1.
For more information, see Chapter 10, “System Procedures” in the Sybase IQ Reference Manual.
Procedure name |
Description |
|---|---|
sp_iqcursorinfo |
Displays information about cursors currently open on the server |
sp_iqdatatype |
Displays information about system data types and user-defined data types |
sp_iqevent |
Displays information about system and user-defined events |
sp_iqhelp |
Displays information about system and user-defined objects and data types |
sp_iqjoinindex |
Displays information about join indexes |
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_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_iqsysmon |
Monitors multiple components of Sybase IQ, including the management of buffer cache, memory, threads, locks, I/O functions, and CPU utilization |
sp_iqwho |
Displays information about all current users and connections or about a particular user or connection |
