PH15483: OBJECT COMPARE HISTORY TABLE ADBC024E UNEXPECT CATALOG ROW ON TARGET FILE EXPECTED FL FOUND CO ADB7380E ADB2CMP SEVERE ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An Object Compare job involving temporal/history tables that
  contain field procedures may end with error messages
  ADBC024E/msgadbc024E and ADB7380E/msgadb7380E:
  
  ADBC024E - Unexpected catalog row on target file. Expected:FL
  found:CO
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of DB2 Object Comparison Tool for Z/OS  *
  *                 who compare temporal/history tables that     *
  *                 contain field procedures.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare may exclude field procedure     *
  *                      information on target side columns      *
  *                      when copying column definitions         *
  *                      from the temporal table to the history  *
  *                      table. This may cause the job to fail   *
  *                      with messages ADBC024E/msgadbc024e and  *
  *                      ADB7380E/msgadb7380E.                   *
  ****************************************************************
  During the compare process, target column information is copied
  from the temporal table to the history table. A column may
  contain a field procedure which is stored as an 'FL' row in the
  version file. This row information is not included when copying
  over the column information. The result is a DDL mismatch, since
  the temporal and history tables must have identical column
  definitions, and now the history table does not contain the
  field procedure information. The job may then fail with the
  following error messages:
  
  ADBC024E - Unexpected catalog row on target file.
  Expected:FL
  found:CO
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped
  

Problem conclusion

• The 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:

  UI66299

Modules/Macros

• ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66299

     UP19/11/12 P F911

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.