PM71812: ABENDU4038-1 ONCODE520 SUBSCRIPTRANGE CONDITION ENTRY POINT CONV_INFO_FOR_ADDED_COLS WHEN USING ALT FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS program ADB27AC fails with User
  Abend Code 4038  REASON CODE 00000001 and message IBM0421S
   ONCODE=520  The SUBSCRIPTRANGE condition was raised.
           From entry point CONV_INFO_FOR_ADDED_COLS at statement
  11713 at compile unit offset +000002B8 at entry offset
            +000002B8 at address 171A3C08.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Alter (ALT) function to     *
  *                 add NOT NULL NO DEFAULT columns into a       *
  *                 table.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Administration Tool for      *
  *                      z/OS when using the ALT function to     *
  *                      add more than one NOT NULL NO DEFAULT   *
  *                      column into a table, the conversion     *
  *                      step of the apply job abends with an    *
  *                      ONCODE520 / ONCODE=520 message:         *
  *                                                              *
  *                      USER ABEND CODE 4038                    *
  *                      REASON CODE 00000001                    *
  *                                                              *
  *                      IBM0421S ONCODE=520 The                 *
  *                         SUBSCRIPTRANGE condition             *
  *                         was raised. From entry point         *
  *                         CONV_INFO_FOR_ADDED_COLS             *
  *                         at statement 11730 at compile        *
  *                         +000002B8 at address >address<.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT function to add more than one NOT NULL NO
  DEFAULT column into a table, the conversion step of the apply
  job abends with an ONCODE520 / ONCODE=520 message:
  
  USER ABEND CODE 4038 REASON CODE 00000001
  
  IBM0421S ONCODE=520 The
      SUBSCRIPTRANGE condition was raised. From entry point
     CONV_INFO_FOR_ADDED_COLS at statement 11730 at
     compile +000002B8 at address >address<.
  

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:

  UK82925 UK82926

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK82925

     UP12/10/30 P F210

• RA20 PSY UK82926

     UP12/10/30 P F210

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.