PI13122: TCZ PANEL CCQPDB2 'DB2 PARAMETERS' / 'DB2 LIBRARIES' / 'DB2 LOAD LIBRARY' VALUE CAUSES DSNUPROC LIB= SYNTAX VIA :BL2LLIB ADBCUST

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Tools Customizer based
  install does not explain on panel CCQPDB2 'DB2 Parameters' that
  specifying a value for the 'DB2 load library' under the 'DB2
  Libraries' section will result in the template ADBCUST job
  containing a value for the :bl2llib nick tag.
  When generating utility jobs that use the DB2-supplied JCL
  procedure DSNUPROC, DB2 Admin sets the symbolic parameter LIB to
  the second library that is specified on this tag.
  This will result in the error IEFC657I THE SYMBOL LIB WAS NOT
  USED if the DSNUPROC does not have a LIB coded.
  

Local fix

• Do not specify the libraries on panel CCQPDB2.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer for z/OS.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Additional field level help information *
  *                      has been provided for input field 'DB2  *
  *                      load libraries' on IBM Tools Customizer *
  *                      for z/OS panel CCQPDB2 'DB2             *
  *                      Parameters'.  The following help        *
  *                      information will now be displayed       *
  *                      when the cursor is positioned on the    *
  *                      input field and F1/Help is entered:     *
  *                                                              *
  *                      Enter the DB2 exit library SDSNEXIT     *
  *                      and DB2 load library SDSNLOAD.  The     *
  *                      specified value for this input field    *
  *                      will be mapped to the :BL2LLIB tag      *
  *                      referenced in the General               *
  *                      Customization job template ADBCUST.     *
  *                      If blank, DB2 Admin Tool will use       *
  *                      the standard operating system search    *
  *                      for DB2 modules.  Note also that DB2    *
  *                      Admin Tool uses DSNUPROC when           *
  *                      generating utility jobs and will        *
  *                      set the LIB= parameter accordingly.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Additional field level help information has been provided for
  input field 'DB2 load libraries' on IBM Tools Customizer for
  z/OS panel CCQPDB2 'DB2 Parameters'.  The following help
  information will now be displayed when the cursor is
  positioned on the input field and F1/Help is entered:
  
  Enter the DB2 exit library SDSNEXIT and DB2 load library
  SDSNLOAD.  The specified value for this input field will
  be mapped to the :BL2LLIB tag referenced in the General
  Customization job template ADBCUST.  If blank, DB2 Admin
  Tool will use the standard  operating system search for DB2
  modules.  Note also that DB2 Admin Tool uses DSNUPROC
  when generating utility jobs and will set the LIB= parameter
  accordingly.
  

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:

  UI17024 UI17025

Modules/Macros

• ADB$$PRM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI17024

     UP14/04/16 P F404

• RB10 PSY UI17025

     UP14/04/16 P F404

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.