SAP Sybase IQ 16.0 includes new and changed system tables and views.
System Table | Contains |
---|---|
ISYSIQMPXSERVERAGENT | New table. Stores agent connection definitions for the given multiplex server. |
ISYSIQPARTITIONCOLUMN | One row for each column of a partition described in
ISYSPARTITION view in a partitioned table described in the
ISYSPARTITIONSCHEME view. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITION System View for details. |
ISYSIQRLVMERGEHISTORY |
New table logging RLV merge events from the RLV store to the IQ main store. A log entry is added for each row-level versioning (RLV) enabled-table each time a merge between the RLV store and the IQ main store begins. Log entries are updated when the merge is complete. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQRLVMERGEHISTORY System View for details. |
ISYSIQRVLOG |
New table tracking RLV log streams. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQRVLOG System View for details. |
ISYSCERTIFICATE |
New table storing certificates in text PEM-format. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSCERTIFICATE System View for details. |
ISYSLDAPSERVER | Contains attributes for the LDAP server. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSLDAPSERVER. |
ISYSPARTITION |
One row for each range subpartition of a hash-range partitioned table. Because Hash partitions are logical rather than physical objects, ISSYPARTITION will not contain any rows for hash partitions of hash partitioned table or hash-range partitioned table. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITION System View for details. |
ISYSPARTITIONKEY* |
One row for each column of a partition key. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITIONKEY System View for details. |
ISYSPARTITIONSCHEME |
One row for each hash partitioned table and each hash-range partitioned table. The hash function and the number of hash partitions per table is fixed for the database and is not stored as part of this table. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSPARTITIONSCHEME System View for details. |
ISYSROLEGRANTEXT | New table containing syntax extensions pertaining to the SET
USER and CHANGE PASSWORD system privileges. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSROLEGRANTEXT. |
ISYSROLEGRANT | New table containing one row for each grant of a system or
user-defined role. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSROLEGRANT. |
ISYSSUBPARTITIONKEY* |
One row for each column of a subpartition key. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSSUBPARTITIONKEY System View for details. |
System Table | Description of Change |
---|---|
ISYSIQDBSPACE |
New column is_rlv_store indicating if the dbspace is a RLV store dbspace. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQDBSPACE System View for details. |
ISYSIQIDX |
Removed columns:
|
ISYSIQTAB |
New column is_rlv indicating if RLV storage is enabled on this table. Removed column join_id. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSIQTAB System View for details. |
ISYSIQTABCOL |
Removed columns:
Added column is_nbit |
ISYSTABLEPERM | Column loadauth and truncateauth added to indicate current grant status of
the object privileges. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSTABLEPERM. |
ISYSUSER | Columns for user_dn and user_dn_cached_at added for LDAP user authentication.
Column user_type added to identify
user type for RBAC. Column dual_password added for the first and second parts of
the dual password for a user. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > Alphabetical List of System Views > SYSUSER. |