Upgrading to Sybase IQ 15.0 adds the following stored procedures:
sa_get_user_status
sp_expireallpasswords
sp_iqbackupdetails
sp_iqbackupsummary
sp_iqcardinality_analysis
sp_iqcopyloginpolicy
sp_iqdbspaceobjectinfo
sp_iqemptyfile
sp_iqfile
sp_iqlmconfig
sp_iqobjectinfo
sp_iqpassword
sp_iqrestoreaction
sp_iqstatistics
For details, see “New sp_iqstatistics procedure”.
New procedures are documented in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
Upgrading to Sybase IQ 15.0 removes the following stored procedures:
sp_iq_post_process_login
sp_iq_process_login
sp_iqlistexpiredpasswords
sp_iqlistlockedusers
sp_iqlistpasswordexpirations
sp_iqlocklogin
sp_iqrelocate
sp_iqretryselectinto
The following changes affect system procedures in Sybase IQ 15.0.
The sp_iqcheckdb procedure has several changes. The repair mode is removed. A new mode dropleaks allows you to reset the allocation map for the entire database or a specified dbspace target. The main and local targets are removed. You can now check a dbspace target and check a subset of the rows of a table that belong to a specified partition. For details, see “sp_iqcheckdb procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
The stored procedure sp_iqdbspace is a new procedure that displays detailed information about each IQ dbspace. The new procedure sp_iqfile now displays the information formerly provided by sp_iqdbspace. For details, see “sp_iqdbspace procedure”and “sp_iqfile procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
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. For details, see “sp_iqdbspaceinfo procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
The following procedures now display a isPartitioned output column: sp_iqtable and sp_iqcolumn. For sample output, see “Stored procedures for dbspace management and partitioning”.
The following procedures now display a dbspace_id output column: sp_iqtable and sp_iqjoinindex. For sample output, see “Stored procedures for dbspace management and partitioning”.
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 |
For sample output, see “sp_iqdbspace procedure”and “sp_iqdbspaceinfo procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
The sp_iqprocparm procedure returns nine columns instead of ten. The remarks column is removed.
Sybase IQ 15.0 no longer has store type IQ local store. The local keyword has been removed from the sp_iqindexinfo and sp_iqspaceinfo stored procedures. LOCAL is no longer a valid value for the location output column of the sp_iqcolumn, sp_iqconstraint, and sp_iqtable procedures. LOCAL is no longer a valid value for the SegmentType output column of sp_iqdbspace.
The following stored procedures now support 3-byte indexes:
sp_iqcheckdb
sp_iqcolumn
sp_iqindexadvice
sp_iqindexmetadata
sp_iqindexsize
sp_iqindex
sp_iqindexfragmentation
sp_rebuildindex
sp_iqrowdensity
