New-function APARs for Db2 13

New capabilities are introduced to Db2 13 through continuous delivery of APARs, in the single Db2 for z/OS® service stream. Many APARs introduce enhancements in Db2 13 immediately when you apply them, at any function level. Other new-function APARs deliver deactivated functional code to support future function levels or enable activation of a new function level.

Tip: Depending on when and how you order the Db2 13 product code, you might find that external changes from any of the following APARs are already built-in when you install or migrate to Db2 13. Also, depending on your maintenance strategy, external changes from APARs that you did not apply in Db2 12 are likely to be already built-in when you migrate to Db2 13. See the descriptions of APARs with availability dates earlier than 2022-06 in New-function APARs for Db2 12.

Each row of the following table summarizes one of the following types of APARs for Db2 13:

  • A new-function APAR that enables new function immediately when its PTF is applied in a Db2 13 subsystem or data sharing member. In data sharing, the new function is available only on members with the PTF applied. Start of changeIf a verifying function level is shown this type of a new-function APAR, activating that function level guarantees the PTF is applied and its new function available in Db2 13, including on all members in data sharing. However, the new function can also be used where the PTF is applied before that function level is activated.End of change

  • An APAR that enables activating a function level, if the Db2 subsystem or all data sharing members have a sufficient code level. The several APARs that introduce new-function code to be activated by each function level are listed in the same row with the APAR that enables activating the function level. The effect of this applying the PTF for this APAR is that the higher function level can be activated if the PTF is applied in a Db2 subsystem or in all active data sharing members. That is, the new-function external changes that the function level introduces do not take effect until you activate the function level by issuing a command. You must first activate function level 500 before you can activate any higher function level. For more information, see Adopting new capabilities in Db2 13 continuous delivery

Tip:

To understand the meaning of function levels that are mentioned in the table, see About function levels and new-function APARs.

Only new-function APARs that have PTFs for Db2 13 are included. That is, the following table does not include any "bug fixes" or other maintenance APARs. The APARs are ordered based on the PTF availability date from most recent to oldest.

Description APAR Release date Function levels1
Function level 507 activation PH64907 2025-04
Ver:FL 507
Eff:FL 500 2
Prefetch for refreshing cross-invalidated buffer pool pages PH65562 2025-04
Ver:FL tbd
Eff:FL 100
IPv4 and IPv6 subnet address support for trusted contexts ADDRESS attribute PH64533 2025-04
Ver:FL tbd
Eff:FL 100
Forward-fit of DSNTXAZP enhancements to Db2 13 PH63793 2025-04
Ver:FL tbd
Eff:FL 100
Addition of the current schema name for dynamic SQL statements to IFCID 350 trace records PH65474 2025-03
Ver:FL tbd
Eff:FL 100
Externalize statement-level zIIP statistics PH64742 2025-03
Ver:FL 507
Eff:FL 100
Datagram message support in MQListener PH63420 2025-02
Ver:FL 507
Eff:FL 100
Enhanced monitoring of work file usage for sorts PH62780 2025-02
Ver:FL 507
Eff:FL 100
Abbreviated spelling APPLCOMPAT supported in SQL syntax PH64377 2025-01
Ver:FL 507
Eff:FL 100
New REST API and shell CLI for SQL Data Insights server administration and AI object-related management 2025-01
Ver:none
Eff:FL 500
EXPLAIN(ONLY) support for Db2 native REST services PH63990 2025-01
Ver:FL 507
Eff:FL 100
AUTHID based monitoring with security profiles PH63652 2025-01
Ver:FL 507
Eff:FL 100
Reduced z/OS console flooding by DSNL030I messages 2025-01
Ver:FL 507
Eff:FL 100
COPY utility zIIP support PH63832 2024-12
Ver:FL 507
Eff:FL 500
Enhancement of EXPLAIN(ONLY) option for REBIND PACKAGE PH61970 2024-11
Ver:FL 507
Eff:FL 100
Partition level support for the MODIFY STATISTICS utility PH63145 2024-11
Ver:FL 507
Eff:FL 100
Function level 506 activation PH62635 2024-10
Ver:FL 506
Eff:FL 500 2
DDF WLM performance blocks moved from ECSA to HVCommon storage PH58162 2024-09
Ver:FL tbd
Eff:FL 100
Allow binding of a location alias to a different IP address for a standalone Db2 subsystems PH62990 2024-09
Ver:FL 506
Eff:FL 100
SPECIFICIMP function support when Db2 calls the WLM sysplex routing service PH62438 2024-09
Ver:FL 506
Eff:FL 100
New statistics for understanding the IP addresses that applications use to access Db2 PH60133 2024-07
Ver:FL 506
Eff:FL 100
Display privilege authority for DISPLAY ML and DISPLAY RLIMIT PH60536 2024-07
Ver:FL 506
Eff:FL 100
Removal of ephemeral port use for DVIPA monitoring from DDF PH58161 2024-06
Ver:FL 506
Eff:FL 100
Enhanced DSNJ114I message output PH60669 2024-06
Ver:FL 506
Eff:FL 100
New model retraining capability of SQL Data Insights PH60870 2024-05
Ver:FL 506
Eff:FL 100
Password phrase support in trusted contexts with JDBC Type 2 drivers 2024-05
Ver:none
Eff:FL 100
Cross-Origin Resource Sharing (CORS) support for Db2 REST services PH59837 2024-04
Ver:FL 506
Eff:FL 100
Function level 505 activation support PH59534 2024-04
Ver:FL 505
Eff:FL 500 2
Utility enhancements for copying table spaces that use XML versions PH51434 2024-03
Ver:FL 505
Eff:FL 100
More granular filtering for monitoring secure connectivity with profiles PH57811 2024-01
Ver:FL 505
Eff:FL 100
Detail information for a page with minimum LRSN that causes a GRECP recovery delay PH54199 2024-01
Ver:FL 505
Eff:FL 100
Improved processing for active log full message DSNJ110E PH56288 2023-12
Ver:FL 505
Eff:FL 100
STATIME_DDF support PH56228 2023-12
Ver:FL 505
Eff:FL 100
Function level 504 activation support PH54919 2023-10
Ver:FL 504
Eff:FL 500 2
Fast index traversal (FTB) controlling rows in SYSIBM.SYSINDEXCONTROL are read more frequently by Db2 PH57071 2023-10
Ver:FL 505
Eff:FL 100
Display privilege authority for DISPLAY PROFILE and DISPLAY DYNQUERYCAPTURE 2023-10
Ver:FL 505
Eff:FL 100
BIND QUERY restriction removed for certain SQL PL packages PH54056 2023-10
Ver:FL 505
Eff:FL 100
Specify MQ administration IDs in DSNTIJRT/DSNTRIN PH55025 2023-09
Ver:FL 505
Eff:FL 100
More granular accounting trace records for distributed applications PH55241 2023-08
Ver:FL 505
Eff:FL 100
Dynamic election of SQL Data Insights vector prefetch on tables PH55212 2023-08
Ver:FL 504
Eff:FL 500
View management authorization enhancements 2023-07
Ver:FL 504
Eff:FL 100
Latch monitoring and serviceability enhancements PH41756 2023-07
Ver:FL 504
Eff:FL 100
Freeing inactive packages for native REST services PH54129 2023-06
Ver:FL 504
Eff:FL 100
Migration readiness reported in DISPLAY GROUP command output PH50072 2023-06
Ver:FL 504
Eff:FL 100
Enhanced SQLDA output for LOBs and distinct types in REXX applications PH52852 2023-04
Ver:FL 504
Eff:FL 100
Generating tailored JCL jobs in batch mode for migrating to Db2 13 or activating function levels PH52482 2023-04
Ver:FL 504
Eff:FL 100
Discovery and granular control for secure TLS connectivity PH48764 2023-03
Ver:FL 504
Eff:FL 100
APPLCOMPAT and PLANMGMT support in DSNTIJRT/DSNTRIN for bind or rebind of packages for Db2-supplied routines PH50704 2023-03
Ver:FL 504
Eff:FL 100
New vector prefetch capability and improved built-in scalar functions of SQL Data Insights PH51892 2023-02
Ver:FL 504
Eff:FL 100
Function level 503 activation support PH51469 2023-02
Ver:FL 503
Eff:FL 500 2
Improved index traverse count information in DISPLAY STATS output PH51565 2023-01
Ver:FL 504
Eff:FL 100
Installation and migration changes to support new EXPLAIN columns PH48053 2023-01
Ver:FL 504
Eff:FL 100
Improved IFCID 0402 reset behavior PH50729 2023-01
Ver:FL 504
Eff:FL 100
Removed stacking limitations for PBG to PBR conversions PH51359 2022-12
Ver:FL 504
Eff:FL 100
Control the maximum number of concurrent user-defined external scalar functions PH44833 2022-12
Ver:FL 504
Eff:FL 100
Lock avoidance for singleton SELECT with ISOLATION(CS) and CURRENTDATA(YES) PH49335 2022-12
Ver:FL 504
Eff:FL 100
Authorization update for CREATE INDEX on DGTT PH48601 2022-11
Ver:FL 504
Eff:FL 100
Product identifier (PRDID) values for specific DRDA levels PH48184 2022-11
Ver:FL 504
Eff:FL 100
Accelerator expression-offload support for LISTAGG and RAND PH48480 2022-11
Ver:FL 504
Eff:FL 100
Improved tape data set estimation for LOAD PH47800 2022-10
Ver:FL 504
Eff:FL 100
Improved PLAN_TABLE.PARENT_PLANNO column data for views and table expressions PH49972 2022-10
Ver:FL 504
Eff:FL 100

Function level V13R1M502 activation support

PH47891 2022-10
Ver:FL 502
Eff:FL 500 2
List prefetch for index access with MERGE statements PH47581 2022-09
Ver:FL 504
Eff:FL 100
Support for UNI_90 locale for the LOWER, TRANSLATE, and UPPER built-in functions PH47187 2022-09
Ver:FL 504
Eff:FL 100
Reduced LOGREC entries for parallel queries with FETCH FIRST n ROWS PH48183 2022-09
Ver:FL 504
Eff:FL 500
Improved DBAT status for MONITOR THREADS profiles in DISPLAY THREAD output PH47626 2022-08
Ver:FL 504
Eff:FL 500
DECFLOAT datatype support for PL/I and C with DCLGEN PH47453 2022-08
Ver:FL 504
Eff:FL 100
Improved DBAT status information in DISPLAY THREAD output PH45504 2022-07
Ver:FL 504
Eff:FL 100
New serviceability message for LOAD FORCE and REORG FORCE PH44941 2022-06
Ver:FL 504
Eff:FL 100
New LOAD option to reclaim NPI space PH46346 2022-05
Ver:FL 504
Eff:FL 100
Improvements to the -START ML and -STOP ML commands PH46031 2022-05
Ver:FL 504
Eff:FL 100
New statistics trace classes for monitoring distributed user statistics PH44815 2022-04
Ver:FL 504
Eff:FL 100
  1. About function levels and new-function APARs

    Ver:FL 5nn means that the specified function level is the verifying function level for a new-function APAR. That is, activating this function level guarantees that the PTF is applied and its new function is available in Db2 13, including on every data sharing member. However, new function in the APAR can be used where the PTF is applied before activation of this function level.

    Ver:FL tbd means that a future to-be-determined function level is expected to verify the APAR. However, new function in the APAR can be used when the PTF is applied at the effective function level.

    Ver:none means that this APAR is not eligible to be verified by a Db2 function level because it is for a different product or FMID, or some other reason.

    Eff:FL 100 means that new-function external changes in the APAR take immediate effect when you apply the PTF on each Db2 subsystem or data sharing member, at any Db2 13 function level. In some cases, a PTF for Db2 12 might also be available.

    Eff:FL 5nn means that new-function external changes in the APAR take effect at the specified function level. In most cases, this is FL 500.

  2. You can activate the higher function level after applying the PTF for this APAR. In a data sharing group, the PTF must be applied on every active Db2 member.

    APARs that are listed in the left column of this row introduce disabled functional code for later activation and are generally transparent to your Db2 environment when you apply the PTF. Their new-function capabilities become available to use only after you issue a command to activate this or a higher function level. Exceptions are noted in the APAR closing text or ++HOLD data.

    For more information, see the description of each function level or Adopting new capabilities in Db2 13 continuous delivery.