IBM Support

Using the DB2 Administration Tool for z/OS V11.2 on DB2 12

Fix Readme


Abstract

Details for using the DB2 Administration Tool for z/OS V11.2 on DB2 12 via APAR PI56130: "PRECONDITIONING APAR FOR THE NEXT VERSION OF DB2", PTF UI35967.

Content

DB2 Administration Tool and Object Comparison Tool v11.2, Instructions for DB2 v12 toleration support:
1. Migrate a subsystem to DB2 12.
2. Invoke DB2 Administration Tool and Object Comparison Tool v11.2 on that subsystem.
Note: No IBM Tools Customizer installation/customization requirements are needed for "DB2 Administration Tool for z/OS" nor for "DB2
Object Comparison Tool for z/OS" where the following IBM Tools Customizer setup can remain without the need to update, regenerate,
and submit customization jobs:
CCQPDB2 DB2 Parameters: DB2 Admin Tool 14:24:42
Command ===> Scroll ===> CSR
Ensure that values are specified for the required DB2 parameters. Press End
to save and exit.
Commands: SAVE VERIFYOFF
More: +
DB2 subsystem ID . . . . . . . . . . . . : DSNB
Group attach name . . . . . . . . . . . . .
Started task name for MSTR services . . . .
General DB2 Information - common
*Mode . . . . . . . . . . . . . . . . . . . NFM (CM, CM8, CM9, NFM)
*Level number . . . . . . . . . . . . . . . 111 (101, 111)
.
.
.
<=== DB2 release level number can remain unchanged.

DB2 High Performance Unload for z/OS Version 4.3 and earlier consideration:

Utility jobs that utilize DB2 HPU receive message INZ1666F when DB2 12 is used:
INZ1666F FATAL ERROR: ODB2CMD UNSUPPORTED DB2VERSION
For that reason, DB2 HPU is blocked from being selected when DB2 12 is used. It will remain blocked until DB2 HPU supports DB2 12.

[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DB2 Administration Tool","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSKM8F","label":"IBM Db2 Administration Solution Pack for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DB2 Administration Tool","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"11.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021

UID

swg22007185