New-function APARs for Db2 13

New capabilities are introduced to Db2 13 through continuous delivery of APARs in a single service stream. Many APARs in Db2 13 deliver deactivated functional code to support future function levels. However, some APARs introduce their enhancements in Db2 13 regardless of the activated function level.

The following table summarizes the new-function APARs for Db2 13 from newest to oldest, including the APARs that enable activation of Db2 13 function levels. APARs with new-function code for future function levels are listed with the APAR that enables activation of each function level. Only new-function APARs that have PTFs for Db2 13 are included. The following table does not include "bug fixes" or other maintenance APARs.

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.

If a verifying function level is listed for an APAR, it is a PREREQ for the enabling APAR for the function level. As a result, activation of the indicated function level verifies that the PTF is applied in Db2 13, including all data sharing members. The verifying function level does not control new-function availability for these APARs. The new function can be used in each data sharing member when the PTF is applied in that member.

Description APAR Date Verifying function level 1
Cross-Origin Resource Sharing (CORS) support for Db2 REST services PH59387 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 verifies that the PTF is applied on every Db2 13 data sharing member. However, new function in the APAR can be used in each member when the PTF is applied on that member.