PI11541: OC COMPARE GENERATES IBM0421S ONCODE=520

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool function Compare generates error:
  IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare system-period temporal      *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Object Comparison Tool for z/OS, *
  *                      when the compared objects include       *
  *                      system-period temporal table, and       *
  *                      SYSTABLES.TYPE is ignored in the        *
  *                      ignore field specification, compare     *
  *                      may abend with an Oncode=520 and        *
  *                      error message ADB7350E / msgadb7350e:   *
  *                                                              *
  *                      ADB7350E Module : ADB2CMT               *
  *                      detected an ONCODE condition            *
  *                      520 in COMPARE_TABLES at nnnn           *
  *                      IBM0421S  ONCODE=520  The               *
  *                      SUBSCRIPTRANGE condition was            *
  *                      raised.                                 *
  *                                                              *
  *                      In DB2 Object Comparison Tool for       *
  *                      z/OS, when comparing DDL with the       *
  *                      catalog and the compared objects        *
  *                      include system-period temporal          *
  *                      table, compare may abend with           *
  *                      Oncode 8094 and error message           *
  *                      ADB7350E / msgadb7350e:                 *
  *                                                              *
  *                      ADB7350E Module : ADB2CMT               *
  *                      detected an ONCODE condition            *
  *                      8094 in ADD_CATREC_OUT                  *
  *                      at nnnnn                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Object Comparison Tool for z/OS, when the compared
  objects include system-period temporal table, and SYSTABLES.TYPE
  is ignored in the ignore field specification, compare may abend
  with an Oncode=520 and error message ADB7350E / msgadb7350e:
  
  ADB7350E Module : ADB2CMT detected an ONCODE condition 520 in
  COMPARE_TABLES at nnn
  
  IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
  
  In DB2 Object Comparison Tool for z/OS, when comparing DDL with
  the catalog and the compared objects include system-period
  temporal table, compare may abend with an Oncode 8094 and
  error message ADB7350E / msgadb7350e:
  
  ADB7350E Module : ADB2CMT detected an ONCODE condition
  8094 in ADD_CATREC_OUT at nnnnn
  

Problem conclusion

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

Modules/Macros

• ADB2CMR  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI17020

     UP14/04/16 P F404

• RB10 PSY UI17021

     UP14/04/16 P F404

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.