PK76269: GOCC024E - UNEXPECTED CATALOG ROW ON TARGET FILE. EXPECTED:TA FOUND:TB WHEN PROCESSING MQT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool issues a message
  GOCC024E - Unexpected catalog row on target file. Expected:TA
  found:TB
  Rowtypes from source file : TB TS VW
  Rowtypes from target file :TB TS CO CO CO VW TA TA TA TB
  when a MQT is identified as the target table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool Ver 7.2. *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool issues a *
  *                      message:                                *
  *                       GOCC024E - Unexpected catalog row on   *
  *                                  target file. Expected:TA,   *
  *                                  found:TB.                   *
  *                      Rowtypes from source file : TB TS VW    *
  *                      Rowtypes from target file : TB TS CO CO *
  *                                                  CO VW TA TA *
  *                                                  TA TB       *
  *                      when source and target include an MQT   *
  *                      and an MQT has an alias.                *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The DB2 Object Comparison Tool issues a message
   GOCC024E - Unexpected catalog row on target file. Expected:TA,
              found:TB
  Rowtypes from source file : TB TS VW
  Rowtypes from target file :TB TS CO CO CO VW TA TA TA TB
  when source and target include an MQT and an MQT has an alias.
  

Problem conclusion

• The code is changed to add logic for processing aliases on MQTs.
  

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:

Modules/Macros

•    GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK43241

     UP09/01/24 P F901

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.