PK18219: OBJECT COMPARE GIVES GOCC026E SEVERE ERROR WHEN GENERATING DDL GOCC002E SEVERE ERROR COMPARE TERMINATES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Table QCT1.IP0036 not found on target
  No syscolumns row found for Create table
  
  GOCC026E Severe Error when generating DDL
  GOCC002E - Severe error. Compare terminates
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who have   *
  *                 same  TABLE name  and different owner name   *
  *                 on the source, may be affected.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare gives the following      *
  *                      error messages:                         *
  *                      GOCC026E - Severe Error when generating *
  *                                 DDL                          *
  *                      GOCC002E - Severe error.                *
  *                                 Compare terminates           *
  *                      .*                                      *
  *                      There are  two  CREATE TABLE statements *
  *                      with  the same table name and different *
  *                      owner name on the source. After masking *
  *                      has been applied, those 2 tables become *
  *                      identical.                              *
  *                      .* Note                                 *
  *                      Duplicate objects on source will now be *
  *                      detected and reported.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK18812

     UP06/10/19 P F610

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.