A fix is available
APAR status
Closed as program error.
Error description
Internal APAR for Bug Smash 2023 (Phase 2)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides fixes to resolve * * the issues described in the summary * * below. * **************************************************************** This APAR includes the following fixes for versions 13.1 and 12.1 of Db2 Admin Tool: 1. A user is creating a change with multiple tables, including one table that has an implicit table space. In the change, one of the explicit table spaces needs to have the REORG utility run, and REORG is run with LISTDEF even though LISTDEF for that table space was not requested. 2. An invalid REORG INDEX statement could be incorrectly generated with FORCEROLLUP YES but without STATISITICS, which causes the utility to fail. 3. A CM batch JCL job uses parameters SOURCE_VERSION_SCOPE_OWNER and SOURCE_VERSION_SCOPE_NAME. When the JCL is submitted, an ADB0006E ADBCCM error is returned. 4. When Object Compare processes dependent stored procedures, ONCODE=150 might occur. 5. A user displays revoke panel ADB2RZ in split screen mode and then cannot scroll down to the Revoke report option. 6. When running REORG, Db2 Admin Tool allows generating the job with the FASTSWITCH and SHRLEVEL NONE options, which causes its failure. 7. Unnecessary debug prints are removed from SYSPRINT for the GEN function (the lines that start with 'ADB2REP:') and Object Compare ('Indicator for PBG->PBR set off for downlevel DB2 release (v13nf not set)') Additionally, the following problems have been resolved for Db2 Admin Tool 13.1 ONLY: 1. The following options are not restored after SAVE and RESTORE execution: ADB2UTC panel (LOAD panel): - PREFORMAT ADB2UPA panel (BATCH panel): - LOB/XML IC Unload - Missing IC Unload - Retry Deprecated Object - Calc space ADB28M (MIGRATE panel): - Statistics table 2. When Object Compare runs ALTER INDEX on an expression-based index, ONCODE=150 might occur. 3. When option 2 is selected on panel ADB2Z2H 'Display Utility History' and a processing error occurs, the "No rows returned" message erroneously displays after clearing the command line and pressing the Enter key.
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH59607
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-02-02
Closed date
2024-03-07
Last modified date
2024-04-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI95998 UI95999
Modules/Macros
ADB28M ADB2CME ADB2CMS ADB2REP ADB2RZ ADB2UPA ADB2USO ADB2UTC ADB2UXO1 ADB2UXOO ADB2Z2H ADBCCM ADBESAVR ADBGAJOB ADBHZ2H
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 April 2024