Catalog changes in Db2 11
This version of Db2 for z/OS® includes changed catalog tables, new catalog tables, and new indexes on catalog tables.
New catalog tables in Db2 11
| Catalog table name | Description |
|---|---|
| SYSINDEXCLEANUP catalog table | The rows in the SYSIBM.SYSINDEXCLEANUP table specify time windows to control index cleanup processing. Each row specifies a time window to enable or disable the cleanup of pseudo-deleted index entries for specific database objects. |
| SYSQUERYPREDICATE catalog table | The SYSIBM.SYSQUERYPREDICATE table contains information about predicates for queries in the SYSIBM.SYSQUERY table that have been identified for extended optimization. It correlates to the SYSIBM.SYSQUERY table by the QUERYID column. |
| SYSQUERYSEL catalog table | The SYSIBM.SYSQUERYSEL table contains information about the selectivity of predicates for queries in the SYSIBM.SYSQUERY table that have been identified for extended optimization. It correlates to the SYSIBM.SYSQUERY table by the QUERYID column. |
| SYSSTATFEEDBACK catalog table | The SYSIBM.SYSTATFEEDBACK table contains information about missing or conflicting catalog statistics for SQL statements. |
| SYSVARIABLEAUTH catalog table | The SYSIBM.SYSVARIABLEAUTH table contains one row for each privilege of each authorization ID that has privileges on a global variable. |
| SYSVARIABLES_DESC catalog table | The SYSIBM.SYSVARIABLES_DESC table is an auxiliary table for the SYSIBM.SYSVARIABLES table. |
| SYSVARIABLES catalog table | The SYSIBM.SYSVARIABLES table contains one row for each global variable that is created. |
| SYSVARIABLES_TEXT catalog table | The SYSIBM.SYSVARIABLES_TEXT table is an auxiliary table for the DEFAULTTEXT column of the SYSIBM.SYSVARIABLES table. |
Changed catalog tables in Db2 11
The following table shows a list of the new columns and the existing columns that are revised. Revisions to columns include new column descriptions, new values for a column, changed data types, changed column lengths, or both changed data types and lengths.
| Catalog table name | New column | Revised column |
|---|---|---|
| SYSCHECKS catalog table | RBA | |
| SYSCOPY catalog table | MODECREATED |
|
| SYSDATATYPES catalog table |
|
|
| SYSDEPENDENCIES catalog table | DVERSION |
|
| SYSINDEXES catalog table |
|
|
| SYSINDEXES_HIST catalog table |
|
|
| SYSINDEXPART catalog table | RBA_FORMAT |
|
| SYSINDEXPART_HIST catalog table |
|
|
| SYSINDEXSPACESTATS catalog table | COPYUDPATELRSN | |
| SYSINDEXSTATS catalog table |
|
|
| SYSINDEXSTATS_HIST catalog table |
|
|
| SYSPACKAGE catalog table |
|
|
| SYSPACKCOPY catalog table |
|
|
| SYSPACKDEP catalog table | BTYPE | |
| SYSPACKSTMT catalog table | EXPANSION_REASON | |
| SYSPARMS catalog table |
|
|
| SYSPENDINGDDL catalog table |
|
|
| SYSPLANDEP catalog table | BTYPE | |
| SYSPLAN catalog table | PROGAUTH | |
| SYSQUERY catalog table |
|
|
| SYSQUERYPLAN catalog table | EXPANSION_REASON | |
| SYSRESAUTH catalog table | QUALIFIER | |
| SYSROUTINES catalog table | COMMIT_ON_RETURN | |
| SYSSEQUENCES catalog table |
|
|
| SYSTABLEPART catalog table |
|
|
| SYSTABLES catalog table |
|
|
| SYSTABLESPACESTATS catalog table |
|
COPYUPDATELRSN |
New and changed indexes in Db2 11
Db2 11
introduces the following new indexes.
| Catalog table | New index |
|---|---|
| SYSCHECKDEP | DSNSDX01 |
| SYSCHECKS | DSNSCX01 |
| SYSCHECKS2 | DSNCHX01 |
| SYSCOPY | DSNUCH01 |
| SYSINDEXCLEANUP | DSNICX01 |
| SYSINDEXSPACESTATS | DSNRTX02 |
| SYSOBD_AUX | DSNOB03 |
| SYSQUERYPREDICATE |
|
| SYSQUERYSEL |
|
| SYSSEQUENCES | DSNSQX03 |
| SYSSTATFEEDBACK |
|
| SYSSTRINGS | DSNSSX01 |
| SYSTABLESPACESTATS | DSNRTX01 |
| SYSTABSTATS | DSNTTX02 |
| SYSVARIABLEAUTH |
|
| SYSVARIABLES | DSNOVX01 |
| SYSVARIABLES_DESC | DSNOVX03 |
| SYSVARIABLES_TEXT | DSNOVX02 |
Db2 11 introduces changes to the following indexes:
| Catalog table | Changed index |
|---|---|
| SYSXMLTYPMOD | DSNTMX01 |
| SYSXMLTYPMSCHEMA | DSNMSX01 |
For more information about catalog index formats in Db2 11, see Catalog indexes.
New built-in global variables
Db2 11 introduces the following built-in global variables:
- CLIENT_IPADDR
- GET_ARCHIVE
- MOVE_TO_ARCHIVE
For descriptions, see Built-in global variables.