Chapter 7, “System Procedures,” includes the new and changed stored procedures that support range partitions and configurable tablespaces. For new procdures, see:
Some existing procedures have new versions and new behavior:
The stored procedure sp_iqdbspace displays detailed information about each IQ dbspace. The procedure sp_iqfile now displays the information formerly provided by sp_iqdbspace in versions prior to 15.0.
A new version of the sp_iqdbspaceinfo stored procedure now displays the size of each object and sub-object used in a specified table or join index and has new keywords.
The following procedures now display a isPartitioned output column: sp_iqtable and sp_iqcolumn.
The following procedures now display a dbspace_id output column: sp_iqtable and sp_iqjoinindex.
This example displays the new dbspace_id and isPartitioned columns:
call sp_iqtable ('Departments') Table_name Table_type Table_owner Server_type location dbspace_id Departments BASE GROUPO IQ Main 16384 isPartitioned Remarks table_constraints N contains the names and heads of the (NULL) various departments in the sporting goods company
The dbspace name column has a different name for the following procedures:
Procedure name |
Old dbspace column name |
New dbspace column name |
---|---|---|
sp_iqdbspace |
Name |
DBSpaceName |
sp_iqindexinfo |
dbspace_name |
DbspaceName |
sp_iqspaceinfo |
dbspace_name |
DbspaceName |
The sp_iqcheckdb procedure has several changes. See “sp_iqcheckdb procedure” in Reference: Building Blocks, Tables, and Procedures.