PI27186: OC COMPARE GENERATES MSG ADB7350E ADBC002E IBM0421S ONCODE 520

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS Compare function
  generates error message ADB7350E IBM0421S ONCODE=520
    ADB7350E Module : ADB2CMT detected an ONCODE condition
                      520 in DROP_OBJECT at 13606
    ADBC002E - Severe error. Compare terminates
    ADB0380E Module ADB2CMP - Severe error Compare  terminates
    IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
              From entry point DROP_OBJECT at statement 13606 at
              compile unit offset
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare system-period           *
  *                 system-period temporal tables.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the Compare function to      *
  *                      compare and DROP/CREATE a system-       *
  *                      period temporal table and history       *
  *                      table defined with the WITH RESTRICT    *
  *                      ON DROP attribute, Object Compare       *
  *                      may fail with an ONCODE 520 /           *
  *                      ONCODE520, and error messages           *
  *                      ADB7350E / msgadb7350e and ADBC002E /   *
  *                      msgadbc002e:                            *
  *                                                              *
  *                      ADB7350E Module : ADB2CMT               *
  *                      detected an ONCODE condition            *
  *                      520 in DROP_OBJECT at 13606             *
  *                      ADBC002E - Severe error.                *
  *                      Compare terminates                      *
  *                      ADB0380E Module ADB2CMP -               *
  *                      Severe error Compare terminates         *
  *                      IBM0421S  ONCODE=520                    *
  *                      The SUBSCRIPTRANGE condition            *
  *                      was raised. From entry point            *
  *                      >entry_point< at statement 13606        *
  *                      at compile unit offset                  *
  *                      >offset_address<                        *
  *                      at entry offset >offset_address<        *
  *                      at address offset_address.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the Compare function to compare and DROP/CREATE a
  system-period temporal table and history table defined with the
  WITH RESTRICT ON DROP attribute, Object Compare may fail with
  an ONCODE 520 / ONCODE520, and error messages ADB7350E /
  msgadb7350e and ADBC002E / msgadbc002e.
  

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
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI23839

     UP14/12/16 P F412

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.