Catalog stored procedure and system stored procedure changes for SAP Sybase IQ 16.0.
| Procedure | Description |
|---|---|
| sa_get_ldapserver_status | New procedure. Allows you to determine the current status of the
LDAP server configuration object. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sa_get_ldapserver_status System Procedure. |
| sa_get_user_status | New output information. For LDAP user authentication, output
includes the distinguished name (DN) for the user and the date and
time the distinguished name was found. For dual control password
management, output includes current status of a dual control
password change, and if active, the user IDs of the two
administrators performing the change. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sa_get_user_status System Procedure. |
| sa_make_object | Behavior change.
Previously, the sa_make_object system procedure
required RESOURCE authority and could be used to create objects
owned by other users, even though RESOURCE authority didn't actually
give a user permissions to create objects owned by others. For
example, if a user with RESOURCE authority attempted to execute the
equivalent CREATE statement, the statement would
fail. Now, when using sa_make_object, you must have all appropriate privileges required to create objects owned by self or others. The actual privileges you need depend on the creation operation you are performing. |
| sa_report_deadlocks |
New procedure. Retrieves information about deadlocks from an internal buffer created by the database server. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sa_report_deadlocks System Procedure. |
| sa_server_option |
Behavior change. New parameters added: rlv_auto_merge and rlv_memory_mb. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sa_server_option System Procedure. |
| sp_auth_sys_role_info | New procedure. Generates a report that maps legacy authorities to
corresponding system roles and role IDs. This procedure returns a
row for each authority. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_auth_sys_role_info System Procedure. |
| sp_alter_secure_feature_key | New procedure. Alters a previously-defined secure feature key by
modifying the authorization key and/or the feature list. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_alter_secure_feature_key system procedure. |
| sp_create_secure_feature_key | New procedure. Creates a new secure feature key. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_create_secure_feature_key system procedure. |
| sp_displayroles | New procedure. Displays all roles granted to a user-defined role
or a user, or displays the entire hierarchical tree of roles. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_displayroles System Procedure. |
| sp_drop_secure_feature_key | New procedure. Deletes a secure feature key. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_drop_secure_feature_key system procedure. |
| sp_list_secure_feature_keys | New procedure. Returns a list of defined secure feature
keys. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_list_secure_feature_keys system procedure. |
| sp_objectpermission | New procedure. Generates a report on object permissions granted
to the specified role or user name or object permissions granted on
the specified object or dbspace. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures> sp_objectpermission System Procedure. |
| sp_proc_priv | New procedure. Generates a report of the minimum system
privileges required to run a stored procedure and pass the
permission check for the procedure. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_proc_priv system procedure. |
| sp_sys_priv_role_info | New procedure. Generates a report to map system privileges to
corresponding system roles and role IDs. A singe row is returned for
each system privilege. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_sys_priv_role_info System Procedure. |
| sp_use_secure_feature_key | New procedure. Enables an existing secure feature key. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of Catalog Stored Procedures > sp_use_secure_feature_keys system procedure. |
| Procedure | Description |
|---|---|
| sp_iqcardinality_analysis |
sp_iqcardinality_analysis no longer returns an index type value or index recommendation. Users are advised to Run Index Advisor for suggestions about additional column indexes. sp_iqcardinality_analysis is deprecated and will be removed in a future release. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqcardinality_analysis. |
| sp_iqcolumn |
Behavior change. sp_iqcolumn no longer includes est_cardinality as part of the output. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqcolumn. |
| sp_iqcolumnmetadata |
New procedure. Returns index metadata for all columns in one or more tables. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqcolumnmetadata. |
| sp_iqconnection | New columns added to display the name of the underlying INC
connection and connection suspension status. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqconnection. |
| sp_iqdbsize |
New columns RLVLogBlocks and RLVLogBytes added. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqdbsize. |
| sp_iqdbspace |
The DBSpace Type column now displays RLV. Block Type R (RLV Free List Manager) is added to the BlkTypes block type identifiers. The Stripingon column is now always F. The StripeSize column is now always 1. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqdbspace. |
| sp_iqdbspaceinfo |
This stored procedure is not supported for RLV dbspaces. The procedure returns no results if you specify an RLV dbspace. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqdbspaceinfo. |
| sp_iqdbspaceobjectinfo |
This stored procedure is not supported for RLV dbspaces. The procedure returns no results if you specify an object located in an RLV dbspace. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqdbspaceobjectinfo. |
| sp_iqemptyfile |
This stored procedure is not supported for RLV dbspaces. The procedure returns an error message f you specify a file located in an RLV dbspace. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqemptyfile. |
| sp_iqfile |
The SegmentType column now displays RLV. Block Type R (RLV Free List Manager) is added to the BlkTypes block type identifiers. The RWMode column is now always RW. The StripeSize column is now always 1. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqfile. |
| sp_iqindexmetadata |
Behavior change. Returns details about column indexes, column constraints, and NBit dictionary size. New HG index output columns include Cardinality Range Min - Max, Estimated Cardinality, and Accuracy of Cardinality. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqindexmetadata. |
| sp_iqindexrebuildwidedata() |
New procedure. Identifies wide columns in migrated databases that you must rebuild before they are available for read/write activities. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqindexrebuildwidedata(). |
| sp_iqlocks |
Behavior change. Support for write-intent locks and row-level locks for RLV. |
| sp_iqmergerlvstore |
New procedure. Triggers a merge of the row-level versioned (RLV) store with the IQ main store. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqmergerlvstore. |
| sp_iqmpxincstatistics | New procedure. Displays a snapshot of the aggregate statistics of
internode communication (INC) status since server startup as of the
moment of execution. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures >sp_iqmpxincstatistics. |
| sp_iqmpxsuspendedconninfo | New procedure. Shows details about currently suspended
connections and transactions on the coordinator node. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqmpxsuspendedconninfo . |
| sp_iqrebuildindex |
Behavior changes. Rebuilds FP indexes (Flat FP as NBit, or NBit as Flat FP); HG indexes (single HG as tiered HG, or tiered HG as single HG); LOB data and columns greater than 255 bytes wide. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqrebuildindex. |
| sp_iqrlvmemory |
New procedure. Monitors RLV store memory usage per table. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqrlvmemory. |
| sp_iqrowdensity |
Behavior change. Returns 1.0 for density in all cases. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqrowdensity. |
| sp_iqspaceused |
New columns rlvLogKB and rlvLogKBUsed added. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqspaceused. |
| sp_iqstatistics |
Behavior change. OperationsActiveLoadTableStatements statistic now returns correct value. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqstatistics. |
| sp_iqstatus |
New output rows:
See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqstatus. |
| sp_iqtable |
New PartitionType column indicates table partition type (Range, Hash, Hash-Range, None). New isRLV column indicates if the table is RLV-enabled. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > . |
| sp_iqtablesize |
New columns RlvLogPages and RlvLogKBytes added. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqtablesize. |
| sp_iqtransaction |
New VersioningType, Blocking, and Blocking Timeout columns. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqtransaction. |