PH46530: GOCCCM ENDS CC 04 WHEN THE SOURCE DDL HAS CREATE AUX TB ONLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GOCCCM (CMBATCH) ends RC 4, but the generated change is failing
  to apply when Compare Source DDL has CREATE AUX table only, and
  when Compare target is the auto extract from the Catalog that
  does not have the object related to the source DDL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for z/OS *
  *                 that have source DDL with CREATE AUX TABLE   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the source DDL has CREATE AUX      *
  *                      TABLE only and the related base table   *
  *                      does not exist at the target, Object    *
  *                      Compare fails to apply the generated    *
  *                      change even though it ends with RC 4.   *
  ****************************************************************
  The input source DDL contains only the CREATE AUX TABLE
  statement and the target does not have the base object that is
  related to the auxiliary table in the source DDL.
  
  This APAR introduces the following changes for this situation:
  1) Change the Object Compare return code from 04 to 08.
  2) Report the new error message ADB7399E
     ADB7399E The auxiliary table <AUX table name> cannot be
              created without its base table <base table name>.
  3) Report warning message ADB7353W instead of the warning
     message ADB7395W when YES is set for the "Scope Warning
     Messages" option (on panel GOC5) or SCOPE_WARNING for CM
     batch.
  
  Keywords: AUXILIARY TABLE, MSGADB7399E, MSGADB7353W, MSGADB7395W
  

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:

  UI81115

Modules/Macros

• ADB2CMR  ADB2CMT  ADB7000  ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI81115

     UP22/06/23 P F206

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.