PH30896: DB2 ADMIN TOOL, CM ERROR: ADB7350E ADB2CMT MODULE: ADB2CMT DETECTED AN ONCODE 520 IN COMPARE_TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AOC: ADB7350E ADB2CMT  Module : ADB2CMT detected an ONCODE
  condition 520 in COMPARE_TABLES at 10347
  
  For example
  
  DDL for a new index on a HISTORY TABLE is imported
  in to CM.  When doing ANALYZE, we see the following error:
  
  Compare table source(PMRKALIX.KMIHB002_CTP_ALIAS) and
          target(PMRKALIX.KMIHB002_CTP_ALIAS)
  
  ADB7350E ADB2CMT  Module : ADB2CMT detected an ONCODE condition
  520 in COMPARE_TABLES at 10347
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Object Comparison Tool for  *
  *                 z/OS who add indexes to history tables.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Analyzing a change to add a new index   *
  *                      to a history table might result in      *
  *                      errors ADB7350E and ADB7380E.           *
  *                                                              *
  *                      The oncode condition line number        *
  *                      may vary depending on the maintenance   *
  *                      applied.                                *
  ****************************************************************
  Importing and then analyzing a change that adds an index to a
  history table causes Compare to use an incorrect index value
  when accessing information on the target and results in the
  following error:
  
  ADB7350E ADB2CMT Module : ADB2CMT detected an ONCODE condition
   520 in COMPARE_TABLES at 10428
  
  ADB7380E ADB2CMP Module ADB2CMP - Severe error Compare has
   been stopped.
  
  The oncode condition line number may vary depending on the
  maintenance applied.
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: MSGADB7350 MSGADB7350E MSGADB7380 MSGADB7380E
  

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:

  UI73702

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73702

     UP21/03/05 P F102

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.