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. If a verifying function level is shown for 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 starting at the effective function level wherever the PTF is applied before that function level is activated. In other words, the effective function level is when you can start using new function wherever the PTF is applied, and the verifying function level is when you know the APAR is fully applied in the Db2 environment.
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

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	Effective function level¹	Verifying function level²
Function level 508 activation support BLOCKING_THREADS table function enhancements (PH65773) Increasing the maximum number of active and archive logs (PH67380) Specify sort work or DGTT usage for PBG table spaces in the work file database (PH67418) Generation of UUID values (PH67554) More local applications control with Db2 profile tables (PH67138) Consistent DSSIZE records in Db2 catalog tables for UTS and LOB objects (PH67419) Rebind phase-in for SQL PL and trigger packages (PH67404) Preparation for conversion of non-UTS catalog and directory objects (PH67554)	PH66983	2025-10	FL 500³	FL 508
Distributed tracing and OpenTelemetry support	PH67971 PH68073	2025-10	FL 100	FL 508
Accounting information on whether a distributed client connection is secure	PH67815	2025-10	FL 100	FL 508
Reduced z/OS console flooding by DSNL030I messages for long user names	PH67051	2025-09	FL 100	FL 508
Improved control over new-connection requests for distributed applications	PH67087	2025-09	FL 100	FL 508
DDF address space (ssnmDIST) added to DSNV508I message	PH62290	2025-08	FL 100	FL 508
DSN1COMP utility enhancements	PH66856	2025-07	FL 100	FL 508
Acceleration support for HASH built-in functions	PH66617	2025-07	FL 100	FL 508
RACF group support in the trusted context SYSTEM AUTHID clause	PH64219	2025-07	FL 100	FL 508
LISTDEF and Db2 installation CLIST enhancements for future catalog and directory conversions	PH66270	2025-07	FL 100	FL 508
Added options for the START ML and STOP ML commands and updated DISPLAY ML command output	PH66471	2025-06	FL 100	FL 508
Enhanced authorization and authentication in SQL Data Insights	PH66445 PH66446 PH66267	2025-06	FL 500	FL 508
LOB support for IBM Db2 Analytics Accelerator (phase 1)	PH62993	2025-06	FL 100	FL 508
New diagnostic level in the profile attributes table to reduce console messages generated during Db2ZAI DCC training	PH65972	2025-06	FL 100	FL 508
Support for a queue parameter in the CAF OPEN function	PH65922	2025-05	FL 100	FL 508
Trusted context support for local and remote connections	PH65634	2025-05	FL 100	FL 508
MODIFY RECOVERY utility DELETEDS override	PH65233	2025-05	FL 500	FL 508
Ability to store the expansion dictionary in the compression dictionary data set	PH64099	2025-05	FL 500	FL 508
Disable generation of GRANT statements for installation jobs	PH63973	2025-04	FL 100	FL 508
Function level 507 activation support Online conversion of table partitioning from PBR to PBG (PH64949, PH64950) Enhanced application availability for system temporal tables (PH65039) LASTUSED column support in the SYSIBM.SYSPLAN catalog table (PH64762) Referencing temporal and archive-enabled tables in the same SELECT statement (PH65133) Specify greater than 64 GB primary and secondary space allocation quantities (PH64760)	PH64907	2025-04	FL 500³	FL 507
Prefetch for refreshing cross-invalidated buffer pool pages	PH65562	2025-04	FL 100	FL 508
IPv4 and IPv6 subnet address support for trusted contexts ADDRESS attribute	PH64533	2025-04	FL 100	FL 508
Forward-fit of DSNTXAZP enhancements to Db2 13	PH63793	2025-04	FL 100	FL 508
Addition of the current schema name for dynamic SQL statements to IFCID 350 trace records	PH65474	2025-03	FL 100	FL 508
Externalize statement-level zIIP statistics	PH64742	2025-03	FL 100	FL 507
Datagram message support in MQListener	PH63420	2025-02	FL 100	FL 507
Enhanced monitoring of work file usage for sorts	PH62780	2025-02	FL 100	FL 507
Abbreviated spelling APPLCOMPAT supported in SQL syntax	PH64377	2025-01	FL 100	FL 507
New REST API and shell CLI for SQL Data Insights server administration and AI object-related management	PH64220 PH64221	2025-01	FL 500	None
EXPLAIN(ONLY) support for Db2 native REST services	PH63990	2025-01	FL 100	FL 507
AUTHID based monitoring with security profiles	PH63652	2025-01	FL 100	FL 507
Reduced z/OS console flooding by DSNL030I messages	PH62137 PH65237	2025-01	FL 100	FL 507
COPY utility zIIP support	PH63832	2024-12	FL 500	FL 507
Enhancement of EXPLAIN(ONLY) option for REBIND PACKAGE	PH61970	2024-11	FL 100	FL 507
Partition level support for the MODIFY STATISTICS utility	PH63145	2024-11	FL 100	FL 507
Function level 506 activation support Non-disruptive clearing of data partitions with LOAD (PH62543) Improved performance for IN-list predicates (PH58750) Db2 trace capacity: More concurrently active traces (PH59020) INSERT with multi-row VALUES clause (PH62561) Add implicitly hidden ROWID columns (PH61629) Lift certain restrictions for column masks (PH62393, PH62690)	PH62635	2024-10	FL 500³	FL 506
DDF WLM performance blocks moved from ECSA to HVCommon storage	PH58162	2024-09	FL 100	FL `tbd`
Allow binding of a location alias to a different IP address for a standalone Db2 subsystems	PH62990	2024-09	FL 100	FL 506
SPECIFICIMP function support when Db2 calls the WLM sysplex routing service	PH62438	2024-09	FL 100	FL 506
New statistics for understanding the IP addresses that applications use to access Db2	PH60133	2024-07	FL 100	FL 506
Display privilege authority for DISPLAY ML and DISPLAY RLIMIT	PH60536	2024-07	FL 100	FL 506
Removal of ephemeral port use for DVIPA monitoring from DDF	PH58161	2024-06	FL 100	FL 506
Enhanced DSNJ114I message output	PH60669	2024-06	FL 100	FL 506
New model retraining capability of SQL Data Insights	PH60870	2024-05	FL 500	FL 506
Password phrase support in trusted contexts with JDBC Type 2 drivers	PH60240 PH54501	2024-05	FL 100	FL 506
Cross-Origin Resource Sharing (CORS) support for Db2 REST services	PH59837	2024-04	FL 100	FL 506
Function level 505 activation support New token-based authentication capability (PH55599) Temporal support for security-related catalog tables (PH59531) New trace destination for Db2ZAI (PH56369) INTERPRET scalar function (PH59595)	PH59534	2024-04	FL 500³	FL 505
Utility enhancements for copying table spaces that use XML versions	PH51434	2024-03	FL 100	FL 505
More granular filtering for monitoring secure connectivity with profiles	PH57811	2024-01	FL 100	FL 505
Detail information for a page with minimum LRSN that causes a GRECP recovery delay	PH54199	2024-01	FL 100	FL 505
Improved processing for active log full message DSNJ110E	PH56288	2023-12	FL 100	FL 505
STATIME_DDF support	PH56228	2023-12	FL 100	FL 505
Function level 504 activation support Minimized impact of invalidated packages with statement-level invalidation (PH55497) Db2 trace capacity: More OP buffers (PH55622) Utility object-level history (PH55476, PH55914, PH55915, and PH55916) Enhancements to SQL Data Insights (PH55212) ORDER BY support for a fullselect that invokes LISTAGG (PH55596)	PH54919	2023-10	FL 500³	FL 504
Fast index traversal (FTB) controlling rows in SYSIBM.SYSINDEXCONTROL are read more frequently by Db2	PH57071	2023-10	FL 100	FL 505
Display privilege authority for DISPLAY PROFILE and DISPLAY DYNQUERYCAPTURE	PH56996 PH56997	2023-10	FL 100	FL 505
BIND QUERY restriction removed for certain SQL PL packages	PH54056	2023-10	FL 100	FL 505
Specify MQ administration IDs in DSNTIJRT/DSNTRIN	PH55025	2023-09	FL 100	FL 505
More granular accounting trace records for distributed applications	PH55241	2023-08	FL 100	FL 505
Dynamic election of SQL Data Insights vector prefetch on tables	PH55212	2023-08	FL 500	FL 504
View management authorization enhancements	PH54863 PH54936	2023-07	FL 100	FL 504
Latch monitoring and serviceability enhancements	PH41756	2023-07	FL 100	FL 504
Freeing inactive packages for native REST services	PH54129	2023-06	FL 100	FL 504
Migration readiness reported in DISPLAY GROUP command output	PH50072	2023-06	FL 100	FL 504
Enhanced SQLDA output for LOBs and distinct types in REXX applications	PH52852	2023-04	FL 100	FL 504
Generating tailored JCL jobs in batch mode for migrating to Db2 13 or activating function levels	PH52482	2023-04	FL 100	FL 504
Discovery and granular control for secure TLS connectivity	PH48764	2023-03	FL 100	FL 504
APPLCOMPAT and PLANMGMT support in DSNTIJRT/DSNTRIN for bind or rebind of packages for Db2-supplied routines	PH50704	2023-03	FL 100	FL 504
New vector prefetch capability and improved built-in scalar functions of SQL Data Insights	PH51892	2023-02	FL 500	FL 504
Function level 503 activation support New default values in existing rows for added ROW CHANGE TIMESTAMP columns (PH51185) Accelerator-only support for more than 32K elements in an IN list (PH50756) SELECT INTO statement support for OPTIMIZE FOR n ROWS (PH50010)	PH51469	2023-02	FL 500³	FL 504
Improved index traverse count information in DISPLAY STATS output	PH51565	2023-01	FL 100	FL 504
Installation and migration changes to support new EXPLAIN columns	PH48053	2023-01	FL 100	FL 504
Improved IFCID 0402 reset behavior	PH50729	2023-01	FL 100	FL 504
Removed stacking limitations for PBG to PBR conversions	PH51359	2022-12	FL 500	FL 504
Control the maximum number of concurrent user-defined external scalar functions	PH44833	2022-12	FL 100	FL 504
Lock avoidance for singleton SELECT with ISOLATION(CS) and CURRENTDATA(YES)	PH49335	2022-12	FL 100	FL 504
Authorization update for CREATE INDEX on DGTT	PH48601	2022-11	FL 100	FL 504
Product identifier (PRDID) values for specific DRDA levels	PH48184	2022-11	FL 100	FL 504
Accelerator expression-offload support for LISTAGG and RAND	PH48480	2022-11	FL 100	FL 504
Improved tape data set estimation for LOAD	PH47800	2022-10	FL 100	FL 504
Improved PLAN_TABLE.PARENT_PLANNO column data for views and table expressions	PH49972	2022-10	FL 100	FL 504
Function level V13R1M502 activation support Db2 controlled sysplex workload balancing (PH48253) Record dependencies and validity at the statement level for packages (PH47560)	PH47891	2022-10	FL 500³	FL 502
List prefetch for index access with MERGE statements	PH47581	2022-09	FL 100	FL 504
Support for UNI_90 locale for the LOWER, TRANSLATE, and UPPER built-in functions	PH47187	2022-09	FL 100	FL 504
Reduced LOGREC entries for parallel queries with FETCH FIRST n ROWS	PH48183	2022-09	FL 100	FL 504
Improved DBAT status for MONITOR THREADS profiles in DISPLAY THREAD output	PH47626	2022-08	FL 500	FL 504
DECFLOAT datatype support for PL/I and C with DCLGEN	PH47453	2022-08	FL 100	FL 504
Improved DBAT status information in DISPLAY THREAD output	PH45504	2022-07	FL 100	FL 504
New serviceability message for LOAD FORCE and REORG FORCE	PH44941	2022-06	FL 100	FL 504
New LOAD option to reclaim NPI space	PH46346	2022-05	FL 100	FL 504
Improvements to the -START ML and -STOP ML commands	PH46031	2022-05	FL 100	FL 504
New statistics trace classes for monitoring distributed user statistics	PH44815	2022-04	FL 100	FL 504

About function levels for new-function APARs

The effective function level indicates the lowest Db2 13 function level where enhancements in the APAR can be used in each subsystem or data sharing member where the PTF is applied Db2. In most cases, it is either FL 100 or FL 500.
Activating the verifying function level indicates that the PTF for the APAR is consistently applied in the Db2 13 environment, including on all members of a Db2 data sharing group. However, the enhancements can be used where the PTF is applied before this function level. FL tbd means that a to-be-determined function level is expected to verify this APAR. 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.
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.