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, regardless of the activated 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

  • A function-level activation APAR that enables activating a Db2 13 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.

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 Availability Date Verifying function level 1
Allow binding of a location alias to a different IP address for a standalone Db2 subsystems PH62990 2024-09  
SPECIFICIMP function support when Db2 calls the WLM sysplex routing service PH62438 2024-09  
DDF WLM performance blocks moved from ECSA to HVCommon storage PH58162 2024-09  
New statistics for understanding the IP addresses that applications use to access Db2 PH60133 2024-07  
Display privilege authority for DISPLAY ML and DISPLAY RLIMIT PH60536 2024-07  
Removal of ephemeral port use for DVIPA monitoring from DDF PH58161 2024-06  
Enhanced DSNJ114I message output PH60669 2024-06  
New model retraining capability of SQL Data Insights PH60870 2024-05  
Password phrase support in trusted contexts with JDBC Type 2 drivers PH60240, PH54501 2024-05 N/A
Cross-Origin Resource Sharing (CORS) support for Db2 REST services PH59837 2024-04  
Function level 505 activation support PH59534 2024-04  
Utility enhancements for copying table spaces that use XML versions PH51434 2024-03 FL 505
More granular filtering for monitoring secure connectivity with profiles PH57811 2024-01 FL 505
Detail information for a page with minimum LRSN that causes a GRECP recovery delay PH54199 2024-01 FL 505
Improved processing for active log full message DSNJ110E PH56288 2023-12 FL 505
STATIME_DDF support PH56228 2023-12 FL 505
Function level 504 activation support PH54919 2023-10  
Fast index traversal (FTB) controlling rows in SYSIBM.SYSINDEXCONTROL are read more frequently by Db2 PH57071 2023-10 FL 505
Display privilege authority for DISPLAY PROFILE and DISPLAY DYNQUERYCAPTURE
PH56996
PH56997
2023-10 FL 505
BIND QUERY restriction removed for certain SQL PL packages PH54056 2023-10 FL 505
Specify MQ administration IDs in DSNTIJRT/DSNTRIN PH55025 2023-09 FL 505
More granular accounting trace records for distributed applications PH55241 2023-08 FL 505
Dynamic election of SQL Data Insights vector prefetch on tables PH55212 2023-08 FL 504
View management authorization enhancements PH54863, PH54936 2023-07 FL 504
Latch monitoring and serviceability enhancements PH41756 2023-07 FL 504
Freeing inactive packages for native REST services PH54129 2023-06 FL 504
Migration readiness reported in DISPLAY GROUP command output PH50072 2023-06 FL 504
Enhanced SQLDA output for LOBs and distinct types in REXX applications PH52852 2023-04 FL 504
Generating tailored JCL jobs in batch mode for migrating to Db2 13 or activating function levels PH52482 2023-04 FL 504
Discovery and granular control for secure TLS connectivity PH48764 2023-03 FL 504
APPLCOMPAT and PLANMGMT support in DSNTIJRT/DSNTRIN for bind or rebind of packages for Db2-supplied routines PH50704 2023-03 FL 504
New vector prefetch capability and improved built-in scalar functions of SQL Data Insights PH51892 2023-02 FL 504
Function level 503 activation support PH51469 2023-02  
Improved index traverse count information in DISPLAY STATS output PH51565 2023-01 FL 504
Installation and migration changes to support new EXPLAIN columns PH48053 2023-01 FL 504
Improved IFCID 0402 reset behavior PH50729 2023-01 FL 504
Removed stacking limitations for PBG to PBR conversions PH51359 2022-12 FL 504
Control the maximum number of concurrent user-defined external scalar functions PH44833 2022-12 FL 504
Lock avoidance for singleton SELECT with ISOLATION(CS) and CURRENTDATA(YES) PH49335 2022-12 FL 504
Authorization update for CREATE INDEX on DGTT PH48601 2022-11 FL 504
Product identifier (PRDID) values for specific DRDA levels PH48184 2022-11 FL 504
Accelerator expression-offload support for LISTAGG and RAND PH48480 2022-11 FL 504
Improved tape data set estimation for LOAD PH47800 2022-10 FL 504
Improved PLAN_TABLE.PARENT_PLANNO column data for views and table expressions PH49972 2022-10 FL 504

Function level V13R1M502 activation support

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

Notes

  1. Activating the verifying function level for a new-function APAR guarantees that its PTF is applied and its new function is available in Db2 13, including on every data sharing member. However, new function in the APAR is available for use before activation of this function level.