Catalog stored procedure and system stored procedure changes for SAP Sybase IQ 16.0 SP2.
| Procedure | Description |
|---|---|
| sp_iqcheckdb |
Changed procedure. sp_iqcheckdb now verifies
the cache dbspace. The cache dbspace is new in this release.
See sp_iqcheckdb Procedure in Reference: Building Blocks, Tables, and Procedures. |
| sp_iqdbspace |
Changed procedure. Displays information about dbspaces of type CACHE. The cache dbspace is new in this release. See sp_iqdbspace Procedure in Reference: Building Blocks, Tables, and Procedures. |
| sp_iqfile |
Changed procedure. Displays detailed information for direct-attached storage device dbfiles in the cache dbspace. The cache dbspace is new in this release. See sp_iqdbfile Procedure in Reference: Building Blocks, Tables, and Procedures. |
| sp_iqindexrebuildwidedata | sp_iqindexrebuildwidedata is deprecated and will be removed in a future release. |
| sp_iqrebuildindexwide | New procedure. Explicitly rebuilds wide columns. SAP Sybase IQ implicitly rebuilds CHAR,VARCHAR, BINARY, and VARBINARY columns wider than 255 characters, as well as all LONG VARCHAR and LONG BINARY columns in databases migrated to SAP Sybase IQ 16.0 SP03 the first time a pre-16.0 non-RLV base table is opened for read-write access.You can also explicitly rebuild wide columns using the sp_iqrebuildindexwide procedure. sp_iqrebuildindexwide can rebuild wide tables by table_name, table_owner, and level. Depending on the argument, this procedure can rebuild all pre-16.0 columns wider than 255 bytes, some or all tokenized FPs, VARCHAR/VARBINARY columns, and all fixed Flat FPs for specified tables in the database. See sp_iqrebuildindexwide Procedure in Reference: Building Blocks, Tables, and Procedures. |
| sp_iqstatus |
Changed procedure. Displays memory usage information for direct-attached storage in the new cache dbspace. See sp_iqstatus Procedure in Reference: Building Blocks, Tables, and Procedures. |
| sp_iqsysmon |
Behavior change. New parameters added: rlv and lma See sp_iqsysmon in Reference: Building Blocks, Tables, and Procedures. |