PM87069: UNLOAD ON A TABLE OR TABLESPACE WITH "LAST IC" SPECIFIED ON ADB2USU BY JCL, UNLOAD(HPU) IS BUILT INTO THE JCL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When executing UNLOAD utility on table or tablespace with "Last
  IC" specified on panel ADB2USU by JCL, and "Use HPU for UNLOAD"
  is specified as "YES" on panel ADBPWLO, UNLOAD(HPU) should NOT
  be specified for ADBTEP2 in the built JCL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When 'Use HPU for UNLOAD' is set to     *
  *                      'YES' on panel ADBPWLO, 'Work           *
  *                      Statement List Options', and the        *
  *                      UNLOAD utility is selected from panel   *
  *                      ADB2UT 'Table Utilities' along with     *
  *                      setting the 'Generate work statement    *
  *                      list' option to NO, the UNLOAD(HPU)     *
  *                      parameter is included in the ADBTEP2    *
  *                      parameters:                             *
  *                                                              *
  *                      //SYSTSIN   DD *                        *
  *                        DSN SYSTEM(>ssid<)                    *
  *                      RUN  PROGRAM(ADBTEP2)                   *
  *                      PLAN(>plan_name<) -                     *
  *                      LIB('>library_name<)  -                 *
  *                      PARMS('/SSID(>ssid<)                    *
  *                      WORKLIST(DB2BATCH)-                     *
  *                       UNLOAD(HPU)  -                         *
  *                       ')                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A Work Statement List (WSL) parameter, UNLOAD(HPU), is included
  in a non-WSL scenario.
  

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:

  UI13855 UI13856 UI13857

Modules/Macros

• ADBSWLP  ADB2TEP  ADB2W1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI13855

     UP13/12/28 P F312

• RA20 PSY UI13856

     UP13/12/28 P F312

• RB10 PSY UI13857

     UP13/12/28 P F312

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.