Db2 12 function levels

New Db2 capabilities and enhancements are continuously delivered in a single maintenance stream as the code becomes ready. You can activate the new capabilities in a data sharing group or Db2 subsystem after a function level is delivered. A function level corresponds to a single PTF that enables the activation of a specific set of enhancements that shipped in previous prerequisite or co-requisite PTFs. The activation of a function level results in the activation of all lower function levels.

Blogs for Db2 for z/OS: See the IBM® Community blog for Db2 for z/OS® and its ecosystem for the latest news about new capabilities and enhancements in Db2 for z/OS continuous delivery, from the IBM experts who design, build, test, and support Db2

Subscribe today!

About function levels in Db2 12

A function level enables a particular set of new Db2 capabilities and enhancements that were previously delivered in the single continuous stream of Db2 code. It includes code that supports new capabilities, defect fixes, and preventive service items. Before you can use the new capabilities of a function level, you must activate the function level, or a higher function level. Activation of a function level implies activation of the capabilities that are introduced by all lower function levels.

For more information about function levels, and how to activate them in Db2 12, see Adopting new capabilities in Db2 12 continuous delivery.

Available function levels in Db2 12

The following function levels are available in Db2 12. They are listed in release order, beginning with the highest available function level.

Function level	New-function capabilities (functional code APARs)	Catalog level	Enabling APAR	Release Date
FL 508	Migration of multi-table table spaces to partition-by-growth universal table spaces (UTS) (PH27370, PH27658, PH27659, PH27660, PH27661, PH27662, PH27663) FTB support for non-unique indexes (PH30978)	V12R1M507	PH29392	2020-10
FL 507	Application granularity for locking limits (NUMLKUS and NUMLKTS) (PH15342) Deletion of old statistics when using profiles (PH16345) CREATE OR REPLACE for procedures (PH24324) Newly supported passthrough-only expressions with IBM Db2 Analytics Accelerator (PH23042)	V12R1M507	PH24371	2020-06
FL 506	Alternative function names support (PH14712) Support for implicitly dropping explicitly created UTS and LOB table spaces (PH14452)	V12R1M505	PH16829	2019-10
FL 505	Rebind phase-in for packages that are being used for execution (PH12186) New built-in functions for encryption and decryption with key labels (PH09506) Improved support for DECFLOAT columns (PH09797) Improved RUNSTATS performance with automatic page sampling by default (PH07220) Temporal and archive transparency support for WHEN clause on triggers (PH09794)	V12R1M505	PH09191	2019-06
FL 504	IBM z14 Huffman compression (PH04424) Prevent creation of new deprecated objects (PH02873) Newly supported built-in functions with IBM Db2 Analytics Accelerator (PH00224) New SQL syntax alternatives for special registers and NULL predicates (PH02646)	V12R1M503	PH07672	2019-04
FL 503	Enablement for replication of system-period temporal tables and generated expression columns Console message for catalog level or function level change Temporal auditing (PI95480)	V12R1M503	PH00506	2018-10
FL 502	Key label management for z/OS DFSMS data set encryption (PI90288) Explicit casting of numeric values to GRAPHIC or VARGRAPHIC (PI88790) Db2 12 migration process changes	V12R1M502	PI95511	2018-05
FL 501	The LISTAGG built-in function	V12R1M500	PI70535	2017-05
FL 500	Application enablement in the Db2 12 initial release Administrator function in the Db2 12 initial release Query performance in the Db2 12 initial release OLTP performance in the Db2 12 initial release Subsystem parameter changes in function level 500 Command changes in function level 500 SQL statement changes in Db2 12 function level 500 Utility changes in function level 500	V12R1M500	None	2016-10
FL 100	Virtual storage enhancements Optimization enhancements Subsystem parameters Various new-function APARs¹	V12R1M500	None	2016-10

Notes:

When the PTF for the APAR is applied in the Db2 subsystem or data sharing member.