IBM Support

Db2 Tools for z/OS compatibility with Db2 13 for z/OS

General Page

This article describes the required maintenance (APARs) for Db2 Tools products to enable compatibility with or make use of Db2 13 for z/OS.

Db2 13 became available in May 2022 and continuously delivers new capabilities and enhancements in function levels. Starting with the GA release, Db2 13 has delivered the following function levels:

To learn more about these function levels, see Db2 13 function levels in the Db2 13 documentation.

As listed in the following sections, a Db2 Tools product must have all required APARs to be compatible with or use Db2 13 at a specific function level. Click the section heading or the preceding  symbol to expand the section for details:

  • Db2 Tool specifies the name and version of a Db2 Tools product.
  • Compatible with Db2 13 indicates that with the required APARs applied, the Db2 Tools product works with Db2 13 as it did on a previous Db2 release, but it cannot use the new functions of Db2 13.
  • Supports Db2 13 new functions indicates that with the required APARs applied, the Db2 Tools product can use the new functions of Db2 13.
  • "No APAR required" indicates that the Db2 Tools product is either compatible with or supports the use of new Db2 13 functions without the application of any additional APARs.
  • The same APAR number listed under "Compatible with Db2 13" and "Supports Db2 13 new functions" indicates that the APAR contains the code for both compatibility and usage support of Db2 13 at the function level.

APARs for Db2 Tools compatibility with Db2 13 at function level 504 (V13R1M504)

Important: If you use IBM Tools Customizer with any of the following Db2 Tools, apply APAR PH42701 to the Tools Customizer before you update the Tool itself.

Db2 Tool Compatible with Db2 13 Supports Db2 13 new functions
IBM Db2 Administration Foundation 1.1 No APAR required No APAR required
IBM Db2 Administration Foundation 1.2 No APAR required No APAR required
IBM Db2 Administration Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Administration Tool for z/OS 13.1 PH57761
PH57762		 PH57761
PH57762
IBM Db2 Analytics Accelerator Loader 2.1 No APAR required No APAR required
IBM Db2 Automation Expert for z/OS 1.1 No APAR required No APAR required
IBM Db2 Automation Tool for z/OS 4.3 No APAR required No APAR required
IBM Db2 Cloning Tool for z/OS 3.2 PH57577 Does not support
IBM Db2 Data Access Common Collector for z/OS 1.1 No APAR required No APAR required
IBM Data Server Client No APAR required No APAR required
IBM Data Server Drivers running on z/OS PH47828 PH47828
IBM Db2 DevOps Experience for z/OS 1.2 Not compatible Does not support
IBM Db2 DevOps Experience for z/OS 1.3 No APAR required No APAR required
IBM Db2 High Performance Unload for z/OS 5.1 PH45499 Does not support
IBM Db2 High Performance Unload for z/OS 5.2 No APAR required Does not support
IBM Db2 Log Analysis Tool for z/OS 3.5 No APAR required No APAR required
IBM Db2 Object Comparison Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Object Comparison Tool for z/OS 13.1
(Only available in certain Db2 solution packs)		 PH57761
PH57762		 PH57761
PH57762
IBM Db2 Query Monitor for z/OS 3.3 No APAR required No APAR required
IBM Db2 Query Monitor for z/OS 3.4 No APAR required No APAR required
IBM Db2 Query Workload Tuner for z/OS 5.2 Not compatible Does not support
IBM Db2 Query Workload Tuner for z/OS 6.1 No APAR required Does not support
IBM Db2 Recovery Expert for z/OS 3.2 PH57922 PH59033
PH59206
IBM Db2 Sort z/OS 2.1 No APAR required Does not support
IBM Db2 SQL Performance Analyzer 5.1 No APAR required No APAR required
IBM Db2 Table Editor 4.5
(Only available in certain Db2 solution packs)		 PH57353 PH57353
IBM Data Virtualization Manager for z/OS 1.1 No APAR required No APAR required
IBM Security Guardium S-TAP for Db2 on z/OS 11.3 No APAR required No APAR required
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5.4 Not compatible Does not support
IBM OMEGAMON for Db2 Performance Expert 5.5 PH57436 PH57436
IBM Tools Customizer for z/OS V1.1 PH556911
Depends on the tool
(that uses the Tools Customizer)
IBM Db2 QMF for z/OS 12.1 - QMF for TSO and CICS component 2 No APAR required No APAR required
IBM Db2 QMF for z/OS 13.1 - QMF for TSO and CICS component 2 No APAR required No APAR required
IBM Unified Management Server for z/OS 1.1 No APAR required No APAR required
IBM Unified Management Server for z/OS 1.2 No APAR required No APAR required
 

1 Apply APAR PH42701 to IBM Tools Customizer before you update the tool that uses Tools Customizer.

2 QMF for TSO and CICS is a component of the following products for the respective version:

  • IBM Db2 QMF for z/OS
  • IBM Db2 feature - QMF Classic Edition
  • IBM Db2 feature - QMF Enterprise Edition

APARs for Db2 Tools compatibility with Db2 13 at function level 503 (V13R1M503)

Important: If you use IBM Tools Customizer with any of the following Db2 Tools, apply APAR PH42701 to the Tools Customizer before you update the Tool itself.

Db2 Tool Compatible with Db2 13 Supports Db2 13 new functions
IBM Db2 Administration Foundation 1.1 No APAR required No APAR required
IBM Db2 Administration Foundation 1.2 No APAR required No APAR required
IBM Db2 Administration Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Administration Tool for z/OS 13.1 PH52918
PH53061		 PH52918
PH53061
IBM Db2 Analytics Accelerator Loader 2.1 No APAR required No APAR required
IBM Db2 Automation Expert for z/OS 1.1 No APAR required No APAR required
IBM Db2 Automation Tool for z/OS 4.3 No APAR required No APAR required
IBM Db2 Cloning Tool for z/OS 3.2 PH53557 PH53557
IBM Db2 Data Access Common Collector for z/OS 1.1 No APAR required No APAR required
IBM Data Server Client No APAR required Minimum v11.1.M2 FP2

IBM Data Server Drivers running on z/OS PH47828 PH47828
IBM Db2 DevOps Experience for z/OS 1.2 No APAR required No APAR required
IBM Db2 DevOps Experience for z/OS 1.3 No APAR required No APAR required
IBM Db2 High Performance Unload for z/OS 5.1 PH45499 Does not support/td>
IBM Db2 High Performance Unload for z/OS 5.2 No APAR required Does not support
IBM Db2 Log Analysis Tool for z/OS 3.5 No APAR required No APAR required
IBM Db2 Object Comparison Tool for z/OS 12.1 Not compatible with Db2 13 Does not support
IBM Db2 Object Comparison Tool for z/OS 13.1
(Only available in certain solution packs)		 PH52918
PH53061		 PH52918
PH53061
IBM Db2 Query Monitor for z/OS 3.3 No APAR required No APAR required
IBM Db2 Query Monitor for z/OS 3.4 No APAR required No APAR required
IBM Db2 Query Workload Tuner for z/OS 5.2 Not compatible Does not support
IBM Db2 Query Workload Tuner for z/OS 6.1 No APAR required Does not support
IBM Db2 Recovery Expert for z/OS 3.2 PH52807 PH52807
IBM Db2 Sort z/OS 2.1 No APAR required Does not support
IBM Db2 SQL Performance Analyzer 5.1

No APAR required No APAR required
IBM Db2 Table Editor 4.5
(Only available in certain Db2 solution packs)		 PH53763 PH53763
IBM Data Virtualization Manager for z/OS 1.1 No APAR required No APAR required
IBM Security Guardium S-TAP for Db2 on z/OS 11.3 No APAR required No APAR required
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5.4 Not compatible Does not support
IBM OMEGAMON for Db2 Performance Expert 5.5 No APAR required PH51040
IBM Tools Customizer for z/OS V1.1 PH523751 Depends on the tool
(that uses the Tools Customizer)
IBM Db2 QMF for z/OS 12.1 - QMF for TSO and CICS component 2 No APAR required No APAR required
IBM Db2 QMF for z/OS 13.1 - QMF for TSO and CICS component 2 No APAR required No APAR required
IBM Unified Management Server for z/OS 1.1 No APAR required No APAR required
IBM Unified Management Server for z/OS 1.2 No APAR required No APAR required

 

1 Apply APAR PH42701 to IBM Tools Customizer before you update the tool that uses Tools Customizer.

2 QMF for TSO and CICS is a component of the following products for the respective version:

  • IBM Db2 QMF for z/OS
  • IBM Db2 feature - QMF Classic Edition
  • IBM Db2 feature - QMF Enterprise Edition

APARs for Db2 Tools compatibility with Db2 13 at function level 502 (V13R1M502)

Important: If you use IBM Tools Customizer with any of the following Db2 Tools, apply APAR PH42701 to the Tools Customizer before you update the Tool itself.

Db2 Tool Compatible with Db2 13 Supports Db2 13 new functions
IBM Db2 Administration Foundation 1.1 No APAR required No APAR required
IBM Db2 Administration Foundation 1.2 No APAR required No APAR required
IBM Db2 Administration Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Administration Tool for z/OS 13.1 PH50890
PH51493		 PH50890
PH51493
IBM Db2 Analytics Accelerator Loader 2.1 No APAR required No APAR required
IBM Db2 Automation Expert for z/OS 1.1 No APAR required No APAR required
IBM Db2 Automation Tool for z/OS 4.3 No APAR required PH50569
IBM Db2 Cloning Tool for z/OS 3.2 PH51158 PH51158
IBM Db2 Data Access Common Collector for z/OS 1.1 No APAR required No APAR required
IBM Data Server Client No APAR required Minimum v11.1.M2 FP2
IBM Data Server Drivers running on z/OS PH47828 PH47828
IBM Db2 DevOps Experience for z/OS 1.2 No APAR required No APAR required
IBM Db2 DevOps Experience for z/OS 1.3 No APAR required No APAR required
IBM Db2 High Performance Unload for z/OS 5.1 PH45499 Does not support
IBM Db2 High Performance Unload for z/OS 5.2 No APAR required Does not support
IBM Db2 Log Analysis Tool for z/OS 3.5 No APAR required No APAR required
IBM Db2 Object Comparison Tool for z/OS 12.1
(Available only in certain solution packs)		 Not compatible Does not support
IBM Db2 Object Comparison Tool for z/OS 13.1
(Available only in certain solution packs)		 PH50890
PH51493		 PH50890
PH51493
IBM Db2 Query Monitor for z/OS 3.3 No APAR required No APAR required
IBM Db2 Query Monitor for z/OS 3.4 No APAR required No APAR required
IBM Db2 Query Workload Tuner for z/OS 5.2 Not compatible Does not support
IBM Db2 Query Workload Tuner for z/OS 6.1 No APAR required Does not support
IBM Db2 Recovery Expert for z/OS 3.2 PH50922 PH50922
IBM Db2 Sort z/OS 2.1 No APAR required No APAR required
IBM Db2 SQL Performance Analyzer 5.1 No APAR required No APAR required
IBM Db2 Table Editor 4.5
(Only available in certain Db2 solution packs)		 PH50748 PH50748
IBM Data Virtualization Manager for z/OS 1.1 No APAR required No APAR required
IBM Security Guardium S-TAP for Db2 on z/OS 11.3 No APAR required No APAR required
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5.4 Not compatible Does not support
IBM OMEGAMON for Db2 Performance Expert 5.5 No APAR required No APAR required
IBM Tools Customizer for z/OS V1.1 PH505171 Depends on the tool
(that uses the Tools Customizer)
IBM Db2 QMF for z/OS 12.1 - QMF for TSO and CICS component 2 No APAR required No APAR required
IBM Db2 QMF for z/OS 13.1 - QMF for TSO and CICS component 2 No APAR required No APAR required
IBM Unified Management Server for z/OS 1.1 No APAR required No APAR required
IBM Unified Management Server for z/OS 1.2 No APAR required No APAR required
 

1 Apply APAR PH42701 to IBM Tools Customizer before you update the tool that uses Tools Customizer.

2 QMF for TSO and CICS is a component of the following products for the respective version:

  • IBM Db2 QMF for z/OS
  • IBM Db2 feature - QMF Classic Edition
  • IBM Db2 feature - QMF Enterprise Edition

APARs for Db2 Tools compatibility with Db2 13 at function level 501 (V13R1M501)

Important: If you use IBM Tools Customizer with any of the following Db2 Tools, apply APAR PH42701 to the Tools Customizer before you update the Tool itself.

Db2 Tool Compatible with Db2 13 Supports Db2 13 new functions
IBM Autonomics Director for Db2 for z/OS 1.6 No APAR required PH43891
PH47937
IBM Db2 Administration Foundation 1.1 PH45035 PH45035
IBM Db2 Administration Foundation 1.2 No APAR required No APAR required
IBM Db2 Administration Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Administration Tool for z/OS 13.1 PH46162
PH46240		 PH46162
PH46240
IBM Db2 Analytics Accelerator Loader 2.1 No APAR required PH45821
IBM Db2 Automation Expert for z/OS 1.1 No APAR required No APAR required

IBM Db2 Automation Tool for z/OS 4.3 PH44145 PH44145
IBM Db2 Cloning Tool for z/OS 3.2 PH45915 PH45915
IBM Db2 Data Access Common Collector for z/OS 1.1 PH43001
PH46139		 PH43001
PH46139
>IBM Data Server Client
(including Db2 Connect)
(Recommended level is mod pack level 11.5.7)		 No APAR required Minimum: Db2 Level v11.1 M1 FP1
IBM Data Server Drivers running on z/OS
(including JDBC (JCC) and SQLJ drivers)
(Recommended level is 4.31.25 provided by Db2 for z/OS APAR PH48861)		 No APAR required No APAR required
IBM Db2 DevOps Experience for z/OS 1.2 PH45030 PH45030
IBM Db2 DevOps Experience for z/OS 1.3 No APAR required No APAR required
IBM Db2 High Performance Unload for z/OS 5.1 PH45499 Does not support
IBM Db2 High Performance Unload for z/OS 5.2 No APAR required Does not support
IBM Db2 Log Analysis Tool for z/OS 3.5 PH45677 PH45677
IBM Db2 Object Comparison Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Object Comparison Tool for z/OS 13.1
(Available as part of Administration Solution Pack 3.3 or Change Management Solution Pack 1.2)		 PH46162
PH46240		 PH46162
PH46240
IBM Db2 Query Monitor for z/OS 3.3 PH44144
PH46138		 PH44144
PH46138
IBM Db2 Query Monitor for z/OS 3.4 No APAR required No APAR required
IBM Db2 Query Workload Tuner for z/OS 5.2 Fixpack 2.1.5.7 1 Does not supports
IBM Db2 Query Workload Tuner for z/OS 6.1 PH53536 2 Does not support
IBM Db2 Recovery Expert for z/OS 3.2 PH45715 PH45715
IBM Db2 Sort z/OS 2.1 No APAR required Does not support
IBM Db2 SQL Performance Analyzer 5.1 PH45320 PH45320
IBM Db2 Table Editor 4.5
(Only available in certain Db2 solution packs)		 PH45716 PH45716
IBM Data Virtualization Manager for z/OS 1.1 PH45855 PH45855
IBM Security Guardium S-TAP for Db2 on z/OS 11.3 PH43062 No APAR required
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5.4 Not compatible Does not support
IBM OMEGAMON for Db2 Performance Expert 5.5 PH46145 PH46145
IBM Tools Customizer for z/OS V1.1 PH42701 3 Depends on the tool
(that uses the Tools Customizer)
IBM Db2 QMF for z/OS 12.1 - QMF for TSO and CICS component 4 No APAR required No APAR required
IBM Db2 QMF for z/OS 13.1 - QMF for TSO and CICS component 4 PH49034 PH49034
IBM Unified Management Server for z/OS 1.1 PH45026 PH45026
IBM Unified Management Server for z/OS 1.2 No APAR required No APAR required
 

1 Select the appropriate version of this fixpack for your operating system.

2 This APAR is for SQL Tuning Services 2.1, which is a component of Db2 Query Workload Tuner 6.1.

3 Apply APAR PH42701 to IBM Tools Customizer before you install updates for any tool that uses the Tools Customizer.

4 QMF for TSO and CICS is a component of the following products for the respective version:

  • IBM Db2 QMF for z/OS
  • IBM Db2 feature - QMF Classic Edition
  • IBM Db2 feature - QMF Enterprise Edition

APARs for Db2 Tools compatibility with Db2 13 at function level 500 (V13R1M500)

Important: If you use IBM Tools Customizer with any of the following Db2 Tools, apply APAR PH42701 to the Tools Customizer before you update the Tool itself.

Db2 Tool Compatible with Db2 13 Supports Db2 13 new functions
IBM Db2 Administration Foundation 1.1 PH45035 PH45035
IBM Db2 Administration Foundation 1.2 No APAR required No APAR required
IBM Db2 Administration Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Administration Tool for z/OS 13.1 PH46162
PH46240		 PH46162
PH46240
IBM Db2 Analytics Accelerator Loader 2.1 No APAR required PH45821
IBM Db2 Automation Tool for z/OS 4.3 PH44145 PH44145
IBM Db2 Cloning Tool for z/OS 3.2 PH45915 PH45915
IBM Db2 DevOps Experience for z/OS 1.2 No APAR required No APAR required
IBM Db2 DevOps Experience for z/OS 1.3 No APAR required No APAR required
IBM Db2 High Performance Unload for z/OS 5.1 PH45499 Does not support
IBM Db2 High Performance Unload for z/OS 5.2 No APAR required Does not support
IBM Db2 Log Analysis Tool for z/OS 3.5 PH45677 PH45677
IBM Db2 Object Comparison Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Object Comparison Tool for z/OS 13.1
(Available as part of Administration Solution Pack or Change Management Solution Pack)		 PH46162
PH46240		 PH46162
PH46240
IBM Db2 Query Monitor for z/OS 3.3 No APAR required No APAR required
IBM Db2 Query Monitor for z/OS 3.4 No APAR required No APAR required
IBM Db2 Query Workload Tuner for z/OS 6.1 No APAR required N/A1
IBM Db2 Recovery Expert for z/OS 3.2 PH45715
PH46701
PH46702		 PH45715
PH46701
PH46702
IBM Db2 Sort z/OS 2.1 No APAR required No APAR required
IBM Db2 SQL Performance Analyzer 5.1 No APAR required No APAR required
IBM Db2 Table Editor 4.5 PH45716 PH45716
IBM Data Virtualization Manager for z/OS 1.1 PH45855 PH45855
IBM Data Virtualization Manager for z/OS 1.2 PH45855 PH45855
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5.4 Not compatible Does not support
IBM OMEGAMON for Db2 Performance Expert 5.5 PH46145
PH57436		 PH46145
IBM Tools Customizer for z/OS V1.1 PH427012 Depends on the tool
(that uses the Tools Customizer)
IBM Db2 QMF for z/OS 12.1 - QMF for TSO and CICS component 3 No APAR required No APAR required4
IBM Db2 QMF for z/OS 13.1 - QMF for TSO and CICS component 3 PH52105
PH52479
PH59315		 PH52105
PH524794
IBM Unified Management Server for z/OS 1.1 PH45026 PH45026
IBM Unified Management Server for z/OS 1.2 No APAR required No APAR required
 

1 This tool does not depend on or use any of the new functions of this Db2 13 function level.

2 Apply APAR PH42701 to IBM Tools Customizer before you install the updates for any tool that uses the Tools Customizer.

3 QMF for TSO and CICS is a component of the following products for the respective version:

  • IBM Db2 QMF for z/OS
  • IBM Db2 feature - QMF Classic Edition
  • IBM Db2 feature - QMF Enterprise Edition

4 QMF must be bound with updated application compatibility levels for exploitation.

APARs for Db2 Tools compatibility with Db2 13 at function level 100 (V13R1M100)

Important: If you use IBM Tools Customizer with any of the following Db2 Tools, apply APAR PH42701 to the Tools Customizer before you update the Tool itself.

Db2 Tool Compatible with Db2 13 Supports Db2 13 new functions
IBM Db2 Administration Foundation 1.1 PH45035 PH45035
IBM Db2 Administration Foundation 1.2 No APAR required No APAR required
IBM Db2 Administration Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Administration Tool for z/OS 13.1 PH46162
PH46240		 PH46162
PH46240
IBM Db2 Analytics Accelerator Loader 2.1 No APAR required PH45821
IBM Db2 Automation Tool for z/OS 4.3 PH16375 PH16375
IBM Db2 Cloning Tool for z/OS 3.2 PH45915 PH45915
IBM Db2 Data Access Common Collector for z/OS 1.1 PH45542
PH46139		 No APAR required
IBM Db2 DevOps Experience for z/OS 1.2 PH45030 PH45030
IBM Db2 DevOps Experience for z/OS 1.3 PH45030 PH45030
IBM Db2 High Performance Unload for z/OS 5.1 PH45499 Does not support
IBM Db2 High Performance Unload for z/OS 5.2 No APAR required Does not support
IBM Db2 Log Analysis Tool for z/OS 3.5 PH45677 PH45677
IBM Db2 Object Comparison Tool for z/OS 12.1 Not compatible Does not support
IBM Db2 Object Comparison Tool for z/OS 13.1
(Available as part of Administration Solution Pack or Change Management Solution Pack)		 PH46162
PH46240		 PH46162
PH46240
IBM Db2 Query Monitor for z/OS 3.3 PH46138 PH46138
IBM Db2 Query Monitor for z/OS 3.4 No APAR required No APAR required
IBM Db2 Query Workload Tuner for z/OS 6.1 No APAR required N/A1
IBM Db2 Recovery Expert for z/OS 3.2 PH45715
PH46701
PH46702
PH55230		 PH45715
PH46701
PH46702
PH55230
IBM Db2 Sort z/OS 2.1 No APAR required No APAR required
IBM Db2 SQL Performance Analyzer 5.1 PH45320 PH45320
IBM Db2 Table Editor 4.5 PH45716 PH45716
IBM Data Virtualization Manager for z/OS 1.1 No APAR required No APAR required
IBM Data Virtualization Manager for z/OS 1.2 No APAR required No APAR required
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5.4 Not compatible Does not support
IBM OMEGAMON for Db2 Performance Expert 5.5 PH46145
PH57436		 PH46145
IBM Tools Customizer for z/OS V1.1 PH427012 Depends on the tool
(that uses the Tools Customizer)
IBM Db2 QMF for z/OS 12.1 - QMF for TSO and CICS component 3 No APAR required No APAR required4
IBM Db2 QMF for z/OS 13.1 - QMF for TSO and CICS component 3 PH52105
PH52479
PH59315		 PH52105
PH524794
IBM Unified Management Server for z/OS 1.1 PH45026 PH45026
IBM Unified Management Server for z/OS 1.2 No APAR required No APAR required
 

1 This tool does not depend on or use any of the new functions of this Db2 13 function level.

2 Apply APAR PH42701 to IBM Tools Customizer before you install the updates for any tool that uses the Tools Customizer.

3 QMF for TSO and CICS is a component of the following products for the respective version:

  • IBM Db2 QMF for z/OS
  • IBM Db2 feature - QMF Classic Edition
  • IBM Db2 feature - QMF Enterprise Edition

4 QMF must be bound with updated application compatibility levels for exploitation.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"ARM Category":[],"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 April 2024

UID

ibm16583559

Page Feedback