Db2 for z/OS and its ecosystem

 View Only

Function level 504 is now available in Db2 13 for z/OS!

By Paul McWilliams posted Thu October 26, 2023 04:16 PM


With the availability of the PTF for APAR PH54919 (October 2023), you can now activate function level V13R1M504 in your Db2 13 for z/OS environment to activate the following new capabilities. 

Minimized impact of invalidated packages with statement-level invalidation

Starting in function level 504, you can now enable packages for statement-level invalidation, with this new capability that builds on the statement-level dependency infrastructure, including the new DEPLEVEL(STATEMENT) bind option, which was introduced in function level 502 of Db2 13.

With statement-level dependencies and statement-level invalidation, applications can execute a package that is invalidated at a statement level without waiting for the completion of the automatic rebind (autobind). The application thread can execute the valid statements immediately. Any invalid statements go through incremental bind in the application thread before execution.

Concurrently, Db2 initiates a special autobind called autobind phase-in When the autobind phase-in finishes successfully, the subsequent executing threads can use the new valid copy of the package, and they no longer use incremental bind for any statements.

APAR PH55497 delivered the functional code for statement-level invalidation.

Increased capacity for Db2 trace: More OP buffers

Starting in function level 504, the maximum number of OP buffers for trace monitoring with READA calls is increased from 8 to 16. The increase in the number of available OP buffers can have the following effects:

  •        More monitoring capacity is available when multiple applications start traces with multiple OP destinations.
  •        Monitoring applications can experience better performance when they send trace data to a larger number of destinations.

APAR PH55622 delivered the functional code for increasing the capacity for Db2 trace.

Utility object-level history 

You can collect object-level information along with utility execution information for IBM® Db2 Utilities. Real time and historical information about the table spaces and index spaces for IBM Db2 Utilities executions are inserted to the SYSIBM.SYSOBJEVENTS catalog table.

System administrators and DBAs can use queries to generate, filter, order, and join the information in the SYSIBM.SYSOBJEVENTS and SYSIBM.SYSUTILITIES catalog tables to check, analyze, and compare utility executions.

The following APARs delivered the functional code for utility object-level history: PH55476, PH55914, PH55915, and PH55916.

Enhancements for SQL data insights 

The new Db2 built-in AI_COMMONALITY function computes a similarity score by using the value of the expression argument and the centroid value of the model column. You can use the function in your queries to detect the common patterns and the outliers in your data. For more information about using this new capability, see Upgrading SQL DI.

APAR PH55212 delivered the functional code for these SQL DI enhancements.

ORDER BY support for a fullselect that invokes LISTAGG

Function level 504 removes a restriction against specifying an ORDER BY clause in a fullselect that contains an invocation of the LISTAGG built-in function for applications that run at application compatibility level V12R1M504 or higher. For more information, see LISTAGG.

APAR PH55622 delivered the functional code for the new LISTAGG capability.

Verification of previous new-function APARs

In continuous delivery for Db2, many enhancements are delivered in “new-function APARs” that take immediate when effect when you apply the PTF in each Db2 subsystem or data sharing member, regardless of the currently activated function level. Even though the new function in these APARs is not controlled by any function level, activating function level 504 in Db2 13 also verifies that the PTFs for many of these previously delivered APARs are applied consistently in your entire Db2 13 for z/OS environment.

For more information about each of thenew capabilities in Db2 13 function level 504, see the online product documentation for Function level 504 (APAR PH54919 - October 2023) and New function APARs for Db2 13.