PI12202: COMPARE MSG ADBC024E UNEXPECTED CATALOG ROW ON SOURCE FILE

Obtain the fix for this APAR.

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 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

• RA20 PSY UI20537

     UP14/08/20 P F408

• RB10 PSY UI20538

     UP14/08/20 P F408

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.