PH23115: CM BATCH OBJECT COMPARE ADB7350E ADB2CMF ONCODE 8094 DROP_OBJECT ADB7380E ADB2CMP SEVERE ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses several scenarios in CM Batch and Object
  Compare where the following error occurs:
  
  ADB7350E ADB2CMF Module : ADB2CMF detected an ONCODE condition
  8094 in DROP_OBJECT at 15756
  
  ADB7380E ADB2CMP  Module ADB2CMP - Severe error Compare has
  been stopped
  
  Note: Statement numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  
  Scenario 1:
  
  Compare on database level, database contains tables that have FK
  to tables in a different DB but with same schema.  Compare fails
  when:
  
  1) Suppress Drop of Objects is set to NO using CM Batch
  
  Scenario 2:
  
  Compare tablespaces with drop of a non-temporal and history
  tablespace due to drop of a table. Compare fails when:
  
  1) Suppress Drop of Objects is set to either YES or NO, and
  Change Management=NO on popup panel ADB2CMRO
  
  Keywords:  msgadb7350E msgadb7380E
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS who require the drop of table spaces    *
  *                 that do not have system-period data          *
  *                 versioning.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGADB7350E ADB2CMF Module :            *
  *                      ADB2CMF detected ONCODE                 *
  *                      condition 8094 in DROP_OBJECT at        *
  *                      15756.                                  *
  ****************************************************************
  When running a comparison that involves dropping tablespaces
  where the tables are not temporal/history tables, Compare
  encounters ONCODE 8094 during the analyze step in multiple
  scenarios:
  
  1. Running a CM batch that involves the dropping of a table
  space that doesn't have system-period data versioning
  (temporal-history tables)
  
  2. Running Object Compare with CM = NO (when prompted on panel
  ADB2CMRO)
  

Problem conclusion

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

  UI69052

Modules/Macros

• ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69052

     UP20/05/02 P F004

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.