PI66879: DB2 ADMIN TOOL OBJECT COMPARE FAILS WITH ADB7350E MODULE : ADB2CMF DETECTED AN ONCODE CONDITION 520

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running a Compare job, job failed with ADB7350E Module :
  ADB2CMF detected an ONCODE condition 520
  
  This APAR will fix the following two problems:
  
  1. ONCODE 520 in KEEP_OBJECT.
     This exists only on v11.2
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool for      *
  *                 z/OS who compare from tablespace level and   *
  *                 specify YES for option 'Suppress DROP of     *
  *                 objects' on panel GOC5 - 'Generate Compare   *
  *                 Jobs'.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare generates ONCODE=520            *
  *                      /oncode520, messages ADB7350E /         *
  *                      msgadb7350e, and IBM0421S /             *
  *                      msgIBM0421s for DB2 Administration      *
  *                      Tool for z/OS Version 11, Release       *
  *                      2 only.                                 *
  *                                                              *
  *                      Also ONCODE=350 / oncode350,            *
  *                      messages ADB7350E / msgadb7350e,        *
  *                      and IBM0361W / msgIBM0361W,             *
  *                      both DB2 Administration                 *
  *                      Tool for z/OS Version 11, Release       *
  *                      1, and Release 2.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using DB2 Object Comparison Tool Version 11, Release 2
  to compare from the tablespace level and specify 'YES' for
  option 'Suppress DROP of objects' on panel GOC5 - 'Generate
  Compare Jobs', the ONCODE=520 error is returned with error
  message:
  
  ADB7350E Module : ADB2CMF detected an ONCODE condition 520 in
           KEEP_OBJECT at 21725.
  IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
  
  Also, when using DB2 Object Comparison Tool Verson 11,
  Release 1 and 2, error ONCODE=350 in COMPARE_VIEWS may occur
  with error message:
  
    ADB7350E Module : ADB2CMP detected an ONCODE condition 340
             in PREPARE_BASE at 7590.
    IBM0361W ONCODE=350  The STRINGRANGE condition was raised.
    From entry point COMPARE_VIEWS at statement 27078 at
    compile unit offset +0000xxxx at entry offset +0000xxxxx
       at address xxxxxxxx.
  

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:

  UI45180

Modules/Macros

•    ADB2CME  ADB2CMF  ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI45180

     UP17/03/07 P F703

• RB20 PSY UI45181

     UP17/03/07 P F703

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.