PI78046: DB2 ADMIN TOOL TO GENERATE STEPLIB FOR DB2 SORT FOR HPU JOBS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 Admin Tool to Generate STEPLIB for DB2 Sort for HPU jobs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use DB2 HPU with DB2            *
  *                 SORT and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Admin Tool is enhanced to include   *
  *                      DB2 SORT load datasets in the STEPLIB   *
  *                      statement when DB2 HPU is invoked.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This enhancement allows the use of the DB2 SORT product in
  conjunction with DB2 High Performance Unload (HPU) during DB2
  Admin functions.
  
  1. The ALT and MIG line commands support DB2 HPU and DB2 SORT
  in the JCL that is produced when the products are configured
  to specify DB2 SORT libraries when using IBM Tools
  Customizer for z/OS via the DB2 Administration Tool for z/OS.
  
  2. New parameters for CM Batch allow the specification of DB2
  Sort:
  
  db2_sort_linklib
    The db2_sort_linklib parameter specifies the DB2
    Sort SCNKLINK library. This data set must be
    APF-authorized. This parameter is only valid when
    parameter Unload_method = 'H' (for HPU) is also
    specified.
  
  db2_sort_lpalib
    The db2_sort_lpalib parameter specifies the DB2
    Sort SCNKLPA library. This data set must be
    APF-authorized. This parameter is only valid when
    parameter Unload_method = 'H' (for HPU) is also
    specified.
  

Problem conclusion

Temporary fix

Comments

• This enhancement allows the use of DB2 SORT product in
  conjunction with DB2 HPU during DB2 Admin functions.
  To support this enhancement, the following new parameters
  have been added to IBM Tools Customizer's DB2 Parameters panel:
  
  DB2 Sort Libraries
    SCNKLINK library . . . . _______________________ Add
    SCNKLPA library . . . . _______________________ Add
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI46965 UI46966 UI46967

Modules/Macros

•    ADB$$PRM ADBCCM   ADBCUST  ADBEALT  ADBGAJOB
  ADBR     ADBTEP2  ADBTHPU  ADBTREL  ADBTTP   ADB2CUST ADB2WL4
  ADB2W1   ADB2000  ADB28HPU ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI46965

     UP17/05/09 P F705

• RB20 PSY UI46966

     UP17/05/09 P F705

• RC10 PSY UI46967

     UP17/05/09 P F705

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.