PI88322: OBJECT COMPARE JOB ENDS RC=12 ADB7350E MODULE : ADB2CMP DETECTED ONCODE CONDITION 8094 IN OUTPUT_ADDCLONE AT 107

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When Compare includes a table in a clone relationship, the
  Compare job may end with RC=12 and the following messages:
  
  ADB7350E Module : ADB2CMP detected an ONCODE condition
  8094 in OUTPUT_ADDCLONE at 10724
  
  ADB7380E Module ADB2CMP - Severe error Compare  has been
  stopped.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who use excludes for           *
  *                 compare.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: A compare operation that uses           *
  *                      excludes and includes a table           *
  *                      in a clone relationship may end         *
  *                      with:                                   *
  *                                                              *
  *                      ADB7350E Module : ADB2CMP               *
  *                      detected an ONCODE condition            *
  *                      8094 in OUTPUT_ADDCLONE at              *
  *                      10724                                   *
  *                                                              *
  *                      ADB7380E Module ADB2CMP -               *
  *                      Severe error Compare has been           *
  *                      stopped.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When Compare uses excludes, and includes a table in a
  clone relationship, the Compare job may end with RC=12
  and the following messages:
  
  ADB7350E Module : ADB2CMP detected an ONCODE
  condition 8094 in OUTPUT_ADDCLONE at 10724
  
  ADB7380E Module ADB2CMP - Severe error Compare
  has been stopped.
  
  In addition, the name of the clone table in the ALTER TABLE
  ADD CLONE statement in the CHG file is incorrect.
  

Problem conclusion

• The problem is resolved for both the ONCODE condition
  in OUTPUT_ADDCLONE and the incorrect ALTER TABLE
  ADD CLONE statement.
  

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:

  UI52220 UI52221

Modules/Macros

•    ADB2CMP  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52220

     UP17/11/30 P F711

• RC10 PSY UI52221

     UP17/11/30 P F711

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.