PH22701: JCL GENERATED BY THE ISPF APPLICATION TAKES UP TO 6 DB2 LIBRARIES INTO ACCOUNT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Only the first two libraries related to a Db2 subsystem
  specified through Tools Customizer are taken in account in the
  JCL generated by the ISPF application.
  
  In some situations, more than 2 libraries are needed. For
  example, Db2 sort is used but the DB2 sort libraries are not
  shared among the Db2 subsystems a set of specific libraries must
  be specified in the Db2 HPU steplib so that Db2 HPU can exploit
  DB2 sort (when SORTUTIL=DB2SORT applies and the unload process
  requires a sort operation).
  
  In such a situation, the JCL generated by the Db2 HPU ISPF
  application cannot be used as is and a manual edit operation to
  add the missing libraries to the Db2 HPU steplib must be done.
  
  To avoid such a manual operation, the ISPF application should
  take the first 6 Db2 load libraries specified through Tools
  Customizer.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Only the first two libraries related to *
  *                      a Db2 subsystem specified through Tools *
  *                      Customizer are taken in account in the  *
  *                      JCL generated by the ISPF application.  *
  *                                                              *
  *                      In some situations, more than 2         *
  *                      libraries are needed. For example, Db2  *
  *                      sort is used but the DB2 sort libraries *
  *                      are not shared among the Db2 subsystems *
  *                      a set of specific libraries must be     *
  *                      specified in the Db2 HPU steplib so     *
  *                      that Db2 HPU can exploit DB2 sort (when *
  *                      SORTUTIL=DB2SORT applies and the unload *
  *                      process requires a sort operation).     *
  *                                                              *
  *                      In such a situation, the JCL generated  *
  *                      by the Db2 HPU ISPF application cannot  *
  *                      be used as is and a manual edit         *
  *                      operation to add the missing libraries  *
  *                      to the Db2 HPU steplib must be done.    *
  *                                                              *
  *                      To avoid such a manual operation, the   *
  *                      ISPF application should take the first  *
  *                      6 Db2 load libraries specified through  *
  *                      Tools Customizer.                       *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  JCL generated by the ISPF application takes up to 6 Db2
  libraries into account
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI69029

Modules/Macros

• INZ$$PRM INZCHECK INZSGEN  INZTDSC  INZTPMEM INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69029

     UP20/04/22 P F004

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.