A fix is available
APAR status
Closed as program error.
Error description
When doing a classic compare, with Use DEFER YES set to YES, the resulting WSL has rebuild out of order, causing the job to fail with an RC=08.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Object Compare fails to generate a * * REBUILD INDEX utility statement, * * preventing the CHECK DATA utility from * * executing successfully. * **************************************************************** An index is in REBUILD-pending status, and the foreign keys of the table are altered. Object Compare generates the needed CHECK DATA statement due to the altered foreign keys, but the operation fails, because the index needs to be rebuilt. KEYWORDS: ADBT015I ADB5184E
Problem conclusion
The problem has been fixed. Object Compare will generate the needed REBUILD INDEX statement, allowing CHECK DATA to complete.
Temporary fix
Comments
APAR Information
APAR number
PH59114
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-01-10
Closed date
2024-07-01
Last modified date
2024-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI97544
Modules/Macros
ADB2ALTJ ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADBGAJOB ADBIREB
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI97544
UP24/07/03 P F407
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":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 August 2024