Catalog levels in Db2 12
Use this information to plan for catalog changes in Db2 12.
Db2 12 catalog levels
The catalog level of a data sharing group or subsystem indicates that a particular CATMAINT utility UPDATE LEVEL job was run on the Db2 catalog, and the data sharing group or Db2 subsystem is ready for the activation of certain function levels.
- V12R1M509
- V12R1M507
- V12R1M505
- V12R1M503
- V12R1M502
- V12R1M500
For more information, see Function levels and related levels in Db2 12.
Catalog changes in catalog level 501 and higher
The following catalog changes take effect in Db2 12 when you tailor the Db2 catalog for activation of the specified function level. The changes are listed in function level order with the highest at the top.
Catalog level | Catalog object | Change introduced | Incompatible change? |
---|---|---|---|
V12R1M509 | SYSTABLEPART catalog table | New column: COMPRESS_USED Changed column: COMPRESS |
No |
V12R1M509 | SYSTABLESPACE catalog table | Changed column: COMPRESS | No |
V12R1M507 | MAX_LOCKS_PER_TABLE_SPACE | New built-in global variable. | No |
V12R1M507 | MAX_LOCKS_PER_USER | New built-in global variable. | No |
V12R1M505 | SYSPACKAGE catalog table | Previously defined unused column now used: COPYID. | No |
V12R1M505 | SYSPACKDEP catalog table | Previously defined unused column now used: COPYID. | No |
V12R1M505 | SYSPACKSTMT catalog table | Previously defined unused column now used: COPYID. | No |
V12R1M503 | REPLICATION_OVERRIDE | New built-in global variable. | |
V12R1M502 | SYSINDEXES catalog table | New column: KEYLABEL. | No |
V12R1M502 | SYSSTOGROUP catalog table | New column: KEYLABEL. | No |
V12R1M502 | SYSTABLESPACE catalog table | New column: KEYLABEL. | No |
V12R1M502 | SYSTABLES catalog table | New column: KEYLABEL. | No |
Catalog changes for function level 100
The following changes catalog take effect when you tailor the catalog Db2 for migration to Db2 12 function level 100 (catalog level V12R1M500).
Catalog object | Change introduced | Incompatible change? |
---|---|---|
CATALOG_LEVEL | New built-in global variable. | No |
DEFAULT_SQLLEVEL | New built-in global variable. | No |
PRODUCTID_EXT | New built-in global variable. | No |
SYSDYNQRY catalog table | New table. New indexes:
|
No |
SYSDYNQRYDEP catalog table | New table. New indexes:
|
No |
SYSDYNQRY_EXPL catalog table | New table. New index: DSNDQX08. |
No |
SYSDYNQRY_OPL catalog table | New table. New index: DSNDQX10. |
No |
SYSDYNQRY_SHTEL catalog table | New table. New index: DSNDQX09. |
No |
SYSDYNQRY_SPAL catalog table | New table. New index: DSNDQX07. |
No |
SYSDYNQRY_TXTL catalog table | New table. New index: DSNDQX06. |
No |
SYSINDEXCONTROL catalog table | New table. | No |
SYSIBM.SYSIXSPACESTATS_H catalog table | New table. See Temporal versioning for Db2 catalog tables. | No |
SYSLEVELUPDATES catalog table | New table. | No |
SYSSESSION catalog table | New table. | No |
SYSSESSION_EX catalog table | New table. | No |
SYSSESSION_STATUS catalog table | New table. | No |
SYSAUDITPOLICIES catalog table | New columns: | No |
SYSCOLUMNS catalog table | New column: ENCODING_SCHEME. Changed column: PERIOD. New index: DSNDCX06. |
No |
SYSCOLAUTH catalog table | New columns: | No |
SYSCONTEXTAUTHIDS catalog table | New columns: | No |
SYSCONTEXT catalog table | New columns: | No |
SYSCONTROLS catalog table | New columns: | No |
SYSCONTROLS_DESC_H catalog table | New table for LOB data in the DESCRIPTOR column of SYSCONTROLS_H. New index: DSNTRX04. |
No |
SYSCONTROLS_RTXT_H catalog table | New table for LOB data in the RULETEXT column of SYSCONTROLS_H. New index: DSNTRX03. |
No |
SYSCOPY catalog table | Changed columns:
|
No |
SYSCTXTTRUSTATTRS catalog table | New columns: | No |
SYSDBAUTH catalog table | New columns: | No |
SYSDEPENDENCIES catalog table | New column: DTYPE | No |
SYSENVIRONMENT catalog table | New columns:
|
No |
SYSINDEXSPACESTATS catalog table | New columns:
Changed column: GETPAGES. |
No |
SYSINDEXES catalog table | New columns:![]()
![]() |
No |
SYSINDEXPART catalog table | New columns:
Changed column: SPACE. |
No |
SYSKEYCOLUSE catalog table | Changed column: PERIOD. | No |
SYSKEYS catalog table | New column: CREATEDTS. Changed column: PERIOD. |
No |
SYSKEYTGTDIST catalog table | Changed column: NUMKEYS. | No |
SYSLEVELUPDATES catalog table | New table. New indexes:
|
No. |
SYSPENDINGDDL catalog table | New columns:
Changed column: PARTITION. |
No |
SYSPACKAGE catalog table | New columns:
Changed columns:
|
No |
SYSPACKAUTH catalog table | New columns: | No |
SYSPACKCOPY catalog table |
|
No |
SYSPACKDEP catalog table | Changed column: DTYPE | No |
SYSPACKSTMT catalog table | New columns:
|
No |
SYSPLANAUTH catalog table | New columns: | No |
SYSQUERY catalog table | New index: DSNQYX04. | No |
SYSRELS catalog table | Changed column: CHECKEXISTINGDATA. | No |
SYSRESAUTH catalog table | New columns: | No |
SYSROUTINES catalog table | New columns:
|
No |
SYSSCHEMAAUTH catalog table | New columns: | No |
SYSSEQUENCEAUTH catalog table | New columns: | No |
SYSSEQUENCES catalog table | Changed column: MAXASSIGNEDVAL. | Yes |
SYSSESSION catalog table | New table. New index: DSNSNX02. |
No |
SYSSESSION_EX catalog table | New table. New indexes:
|
No |
SYSSESSION_GV catalog table | New table for LOB data in the GLOBAL_VARIABLES column of the SYSSESSION table. New index: DSNSNX01. |
No |
SYSSESSION_DATA catalog table | New table for LOB data in the DATA column of the SYSSESSION_EX table. New index: |
No |
SYSSESSION_STATUS catalog table |
New index: DSNSNX06. |
No |
SYSTABAUTH catalog table | New columns: | No |
SYSTABCONST catalog table | Changed column: TYPE. | No |
SYSTABLEPART catalog table | New columns:
Changed column: SPACE. |
No |
SYSTABLESPACE catalog table | New columns:
|
No |
SYSTABLES catalog table | New column: REGENERATETS. Changed column: TABLESTATUS. |
No |
SYSTABLESPACESTATS catalog table | New columns:
Changed column: |
No |
SYSSTATFEEDBACK catalog table | Changed column: REASON. | No |
SYSTRIGGERS catalog table | New columns:
|
No |
SYSUSERAUTH catalog table | New columns: | No |
SYSVARIABLES catalog table | Changed columns:
New index: DSNSNX06. |
No |
SYSVIEWDEP catalog table | New columns: | No |
SYSIBM.SYSTABSPACESTATS_H catalog table | New table. See Temporal versioning for Db2 catalog tables. | No |
SYSAUDITPOLICIES_H catalog table | New unused table. | No |
SYSCOLAUTH_H catalog table | New unused table. | No |
SYSCONTEXT_H catalog table | New unused table. | No |
SYSCONTEXTAUTHID_H catalog table | New unused table. | No |
SYSCONTROLS_H catalog table | New unused table. | No |
SYSCTXTTRUSTATTR_H catalog table | New unused table. | No |
SYSDBAUTH_H catalog table | New unused table. | No |
SYSPACKAUTH_H catalog table | New unused table. | No |
SYSPLANAUTH_H catalog table | New unused table. | No |
SYSRESAUTH_H catalog table | New unused table. | No |
SYSROUTINEAUTH_H catalog table | New unused table. | No |
SYSSCHEMAAUTH_H catalog table | New unused table. | No |
SYSSEQUENCEAUTH_H catalog table | New unused table. | No |
SYSTABAUTH_H catalog table | New unused table. | No |
SYSUSERAUTH_H catalog table | New unused table. | No |
SYSVIEWDEP_H catalog table | New unused table. | No |
TEMPORAL_LOGICAL_TRANSACTION_TIME | New built-in global variable. | No |
TEMPORAL_LOGICAL_TRANSACTIONS | New built-in global variable. | No |
- Reserved for future IBM use.