PH12267: Admin Tool compare DDL ONCODE=520 / ONCODE520 SUBSCRIPTRANGE CATREC_INDEX INDEX PARTITIONED TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDL processing may end with the following error messages
  when processing an index which belongs to a partitioned table:
  Error occurred processing DDL statement
  
  
  Length of stmt: [length]
  DDL statement
  IBM0421S ONCODE=520 The SUBSCRIPTRANGE condition was raised.
  From entry point CATREC_INDEX at statement 6424 at compile
  unit offset >offset< at address <address>.
  Note: Line numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for       *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: #1                                      *
  *                      DDL command may end with ONCODE=520/    *
  *                      ONCODE520 when processing an index.     *
  *                                                              *
  *                      #2                                      *
  *                      Change management may return an         *
  *                      ONCODE=350/ONCODE350 when registering   *
  *                      a change.                               *
  *                                                              *
  *                      #3                                      *
  *                      Change Management (CM) Batch scenario   *
  *                      involving object compare operation may  *
  *                      end with ONCODE8094/ONCODE=8094 error.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  #1
  DDL command may end with the following error messages
  when processing an index which belongs to a partitioned table:
  
  Error occurred processing DDL statement
  
  Length of stmt:  length
  DDL statement
  
  IBM0421S ONCODE=520 The SUBSCRIPTRANGE condition was raised.
  From entry point CATREC_INDEX at statement 6424 at compile
  unit offset >offset< at address <address>.
  Note: Line numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  
  #2
  When defining a change in Change Management on a target for
  which there is already an existing analyzed change, the
  following error appears.
  
  IBM0361W ONCODE=350 The STRINGRANGE condition was raised.
  From entry point GET_SYSPARM at statement 4924 at compile unit
  offset +00000C64 at entry offset +00000C64 at address 373443FC.
  
  Note: Line numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  
  #3
  Change Management (CM) Batch scenario involving object compare
  operation may end with ONCODE8094/ONCODE=8094 error as below.
  
  ADB7350E Module : ADB2CMP detected an ONCODE condition 8094 in
  GET_SYSPARM at 0
  ADB7380E Module ADB2CMP - Severe error Compare has been
  stopped.
  
  Note: Line numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  

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:

  UI63342

Modules/Macros

•    ADBCDTS  ADB2CID  ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63342

     UP19/06/04 P F906

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.