A fix is available
APAR status
Closed as program error.
Error description
The DB2 Object Comparison Tool Compare function generates message ADBC024E - Unexpected catalog row on source file when comparing the catalog entries for two Databases.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool * * for z/OS who alter an index to change the * * number of columns in the index key when the * * INCLUDE_COLUMNS generic ignore field is * * specified. * **************************************************************** * PROBLEM DESCRIPTION: When altering the number of columns in * * an index key, the INCLUDE_COLUMNS * * generic ignore field was selected on * * panel GOCCIF 'Select Ignore Fields * * for GENERIC', and no include column * * column was defined on the index, a * * change statement was not generated * * for the index and an ADBC024E / * * msgadbc024e error message is observed * * in the job log: * * * * ADBC024E - Unexpected catalog * * row on source file. Expected:KY * * found:IP * **************************************************************** * RECOMMENDATION: * **************************************************************** If the INCLUDE_COLUMNS generic ignore field is specified during a comparison, the include columns permissions will not be compared, added or dropped. Also, changes to the indexes which does not have any include column specifications in their definition should not be impacted.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI12202
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-02-20
Closed date
2014-08-14
Last modified date
2014-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI20538
Modules/Macros
ADB2CMF
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 September 2014