Activation details summary for function levels

• SYSIBM.SYSTABLESPACE
• SYSIBM.SYSTABLEPART

• UPDATE or DELETE from the parent table in a temporal RI relationship.

• MAX_LOCKS_PER_TABLE_SPACE
• MAX_LOCKS_PER_USER

• The SYSIBMADM.MAX_LOCKS_PER_TABLESPACE built-in global variable for overriding the NUMLKTS subsystem parameter.
• The SYSIBMADM.MAX_LOCKS_PER_USER built-in global variable for overriding the NUMLKUS subsystem parameter.
• CREATE PROCEDURE with the OR REPLACE and SPECIFIC clauses for external procedures and native SQL procedures.
• Newly supported passthrough-only expressions.

• Newly supported names for existing built-in functions.
• DROP statement enhancements for implicitly dropping explicitly created table spaces.

A new COPYID column is added in the following tables:

• SYSIBM.SYSPACKDEP
• SYSIBM.SYSPACKSTMT

• All built-in functions described in New built-in functions for encryption and decryption with key labels.
• Creating a new index with a DECFLOAT column as a key, or adding a DECFLOAT column to an existing index.
• Defining a primary or unique constraint with a DECFLOAT column.
• Temporal and archive transparency support for WHEN clause on triggers.

• All new SQL syntax described in New SQL syntax alternatives for special registers and NULL predicates.
• All built-in functions described in Newly supported built-in functions with IBM Db2 Analytics Accelerator.
• Preventing the creation of deprecated object types, as described in Prevent creation of new deprecated objects.

For a summary of changes in Db2 12, see Catalog changes in Db2 12.

• The SYSIBMADM.REPLICATION_OVERRIDE built-in global variable for replication of system-period temporal tables and generated expression columns.
• The temporal query result change for system-period temporal tables defined with the ON DELETE ADD EXTRA ROW attribute that also contain a DATA CHANGE OPERATION column.

• SYSIBM.SYSINDEXES
• SYSIBM.SYSSTOGROUP
• SYSIBM.SYSTABLESPACE
• SYSIBM.SYSTABLES

Restriction: Before you can run CATMAINT to tailor the Db2 catalog for function level 502 or higher, you must first activate function level 500 or 501. That is, the DISPLAY GROUP command output must indicate HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M500) or higher. This restriction prevents tailoring the Db2 catalog for function levels higher than 500 while fallback to Db2 11 remains possible. However, later activating a lower function level such as function level 100* does not restrict the CATMAINT operation.

For a summary of changes in Db2 12, see Catalog changes in Db2 12.

• CREATE or ALTER statements that specify the KEYLABEL option. However, applications that already reference encrypted data can continue to run at their current application compatibility levels.
• Explicit casting of numeric data types to fixed or variable length graphic strings, with the GRAPHIC or VARGRAPHIC built-in functions or the CAST specification.

IBM data server clients and drivers that use the capabilities in function level 501 or are bound with application compatibility level V12R1M501 or higher, require extra program preparation steps. For instructions, see Setting application compatibility levels for data server clients and drivers.