PI78813: GOC - 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

• GOC - DB2 ADMIN TOOL TO GENERATE STEPLIB FOR DB2 SORT FOR HPU
  JOBS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS and IBM Tools Customizer for        *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: With companion APAR PI78046, DB2 Admin  *
  *                      Tool is enhanced to include DB2 SORT    *
  *                      load datasets in the STEPLIB statement  *
  *                      when DB2 HPU is invoked.                *
  *                                                              *
  *                      This APAR has changes in common with    *
  *                      the DB2 Admin APAR.                     *
  ****************************************************************
  * 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:

  UI46969 UI46968 UI46970

Modules/Macros

•    GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB10 PSY UI46968

     UP17/05/09 P F705

• RB20 PSY UI46969

     UP17/05/09 P F705

• RC10 PSY UI46970

     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.