PI07836: DB2 ADMINISTRATION TOOL FOR Z/OS CLONE WSL FUNCTION RESULTS IN USER ABEND 4,038 DEC PROCESSING COMMAND 'ADB2WCL '

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS CLONE WSL function results
  in User abend 4,038 dec processing command 'ADB2WCL '
  .
  Other symptoms:
  .
  FUNCTION = ADB2W1QB, LINE 268: SELECT CMD(ADB2WCL
  .
  msgIBM0421S
  .
  IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
           From entry point TOKEN_VALUE at statement xxxxxx at
  compile unit offset
           at address aaaaaaaaa.
  ERROR condition was raised
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 DB2 Administration Tool     *
  *                 for z/OS who clone a Work Statement List     *
  *                 (WSL) and specify mask on panel ADB2W1Q      *
  *                 'Clone Work Statement List'.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS        *
  *                      CLONE WSL function results in an        *
  *                      Abend U4038 processing                  *
  *                      command 'ADB2WCL ' when the source      *
  *                      WSL contains a 'DELETE FROM             *
  *                      >table_name<' statement.                *
  *                                                              *
  *                      Other symptoms:                         *
  *                                                              *
  *                      FUNCTION = ADB2W1QB,                    *
  *                      LINE 268:                               *
  *                      SELECT CMD(ADB2WCL)                     *
  *                      .                                       *
  *                                                              *
  *                      msgIBM0421S                             *
  *                      .                                       *
  *                      IBM0421S  ONCODE=520  The               *
  *                      SUBSCRIPTRANGE condition                *
  *                      was raised.                             *
  *                               From entry point               *
  *                      TOKEN_VALUE at statement                *
  *                      xxxxxx at compile unit offset           *
  *                               at address aaaaaaaaa.          *
  *                      ERROR condition was raised              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Cloning a WSL that contains a 'DELETE FROM >table_name<'
  statement fails.
  

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

• ADB2WCL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI14217

     UP14/01/16 P F401

• RA20 PSY UI14218

     UP14/01/16 P F401

• RB10 PSY UI14219

     UP14/01/16 P F401

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.