PI14757: ALTERING INDEX GENERATES ERROR MSG ADB7350E IBM0421S ONCODE=520

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALTER Function on an Index
  generates error:
   ADB7350E Module : ADB2CMF detected an ONCODE condition 520 in
                     PROCESS_INCLUDED_COLUMNS at nnnnn
   IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
             From entry point PROCESS_INCLUDED_COLUMNS at
             statement nnnnn
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Comparison Tool for         *
  *                 z/OS who use the 'ALT Alter Table'           *
  *                 (ALT) function or Compare function to        *
  *                 change the INCLUDE columns for an            *
  *                 unique index.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for          *
  *                      z/OS and DB2 Comparison Tool            *
  *                      for z/OS, changing the INCLUDE          *
  *                      columns to the unique keys for an       *
  *                      unique index will result in the         *
  *                      error ONCODE = 520 / Oncde 520          *
  *                      and error message ADB7350E /            *
  *                      msgadb7350e:                            *
  *                                                              *
  *                      ADB7350E Module : ADB2CMF               *
  *                      detected an ONCODE condition 520 in     *
  *                      PROCESS_INCLUDED_COLUMNS                *
  *                      at 21174                                *
  *                      IBM0421S ONCODE=520 The                 *
  *                      SUBSCRIPTRANGE condition was            *
  *                      raised.                                 *
  *                      From entry point                        *
  *                      PROCESS_INCLUDED_COLUMNS                *
  *                      at statement 21174 at compile           *
  *                      +00002204 at address nnnnnnnn.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS and DB2 Comparison Tool
  for z/OS, changing the INCLUDE columns to the unique keys
  for an unique index will result in the error ONCODE = 520 /
  Oncode 520 and error message ADB7350E / msgadb7350e:
  
  ADB7350E Module : ADB2CMF detected an ONCODE condition
  520 in PROCESS_INCLUDED_COLUMNS  at 21174
  IBM0421S ONCODE=520 The SUBSCRIPTRANGE condition
  was raised.   From entry point PROCESS_INCLUDED_COLUMNS
  at statement 21174 at compile +00002204 at address nnnnnnnn.
  

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

•    ADBCMPDB ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI19998

     UP14/07/30 P F407

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.