PI19134: INSTALLING DB2 ADMINISTRATION TOOL TEMPLATE ADBCUST GENERATES DUPLICATE VALUES FOR THE GLOBAL AND DB2 SETTINGS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During the Install process of the DB2 Administration Tool for
  z/os specifying the WLM Environment Name in Panel CCQPDB2 DB2
  Parameters generates duplicates values in Template ADBCUST for
  the  PRODUCT PARAMETERS (GLOBAL SETTINGS) and the DB2 Parameters
  for the WLM Environnment.  For example,
  hlq.llq(A0CUSTAA)
  000141 *********************************************************
  000142 * PRODUCT PARAMETERS (GLOBAL SETTINGS)
  000143 ********************************************************
  000144 :NICK.*
  000184 * WLM ENVIRONMENT NAME
  000185 :wlmname
  000527 ********************************************************
  000528 * DB2 PARAMETERS
  000529 *
  000530 * DB2 SUBSYSTEM ID     : ssid
  000535 :NICK.ssid
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues have been          *
  *                      resolved:                               *
  *                                                              *
  *                      1.  Blanking out the value for the      *
  *                      following input fields from panel       *
  *                      CCQPPRD 'Product Parameters' appears    *
  *                      as :ADBCT.NO and :ADBTE.NO in the       *
  *                      generated job template ADBCUST,         *
  *                      respectively in the Product             *
  *                      Parameters section (:NICK.*)            *
  *                      which is misleading even though the     *
  *                      default value "NO" is correct:          *
  *                                                              *
  *                      Enable DB2 Cloning Tool  . . (YES, NO)  *
  *                      Enable DB2 Table Editor  . . (YES, NO)  *
  *                                                              *
  *                      Fix:                                    *
  *                      To alleviate confusion, a blank input   *
  *                      value is no longer allowed for these    *
  *                      two Product Parameters input fields.    *
  *                                                              *
  *                      2.  A blank value is allowed for the    *
  *                      following DB2 Parameters input fields:  *
  *                                                              *
  *                      Enable DB2 Cloning Tool  . . (YES, NO)  *
  *                      Enable DB2 Table Editor  . . (YES, NO)  *
  *                                                              *
  *                      However, in job template ADBCUST, the   *
  *                      comment records for the two input field *
  *                      does not mention that a blank value     *
  *                      is allowed.                             *
  *                                                              *
  *                      Fix:                                    *
  *                      Associated comment records for the      *
  *                      DB2 Parameters input fields have been   *
  *                      updated with information stating that   *
  *                      a blank value is allowed.               *
  *                                                              *
  *                      3. The following Product Parameters     *
  *                      and DB2 Parameters input field          *
  *                      descriptions are misleading and can     *
  *                      suggest that creating the Change        *
  *                      Management (CM) database is             *
  *                      optional when it's not:                 *
  *                                                              *
  *                      Enable Change Management . . (YES, NO)  *
  *                                                              *
  *                      Fix:                                    *
  *                      The input field description,            *
  *                      field-level help, and comment records   *
  *                      in job template ADBCUST have been       *
  *                      updated to better describe its          *
  *                      purpose/function.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following issues have been resolved:
  
  1.  Blanking out the value for the following input fields from
  panel CCQPPRD 'Product Parameters' appears as :ADBCT.NO and
  :ADBTE.NO in the generated job template ADBCUST, respectively
  in the Product Parameters section (:NICK.*) which is misleading
  even though the default value "NO" is correct:
  
  Enable DB2 Cloning Tool  . . . . . . . . . ___  (YES, NO)
  Enable DB2 Table Editor  . . . . . . . . . ___  (YES, NO)
  
  Fix:
  To alleviate confusion, a blank input value is no longer
  allowed for these two Product Parameters input fields.
  
  2.  A blank value is allowed for the following
  DB2 Parameters input fields:
  
  Enable DB2 Cloning Tool  . . . . . . . . . ___  (YES, NO)
  Enable DB2 Table Editor  . . . . . . . . . ___  (YES, NO)
  
  However, in job template ADBCUST, the comment records for the
  two input fields does not mention that a blank value is
  allowed.
  
  Fix:
  Associated comment records for the DB2 Parameters input fields
  have been updated with information stating that a blank value
  is allowed.
  
  3. The following Product Parameters and DB2 Parameters input
  field descriptions are misleading and can suggest that
  creating the Change Management (CM) database is optional
  when it's not:
  
  Enable Change Management . . . . . . . . ___ (YES, NO)
  
  Fix:
  The input field description, field-level help, and comment
  records in job template ADBCUST have been updated to better
  describe its purpose/function.
  

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:

  UI19182 UI19183

Modules/Macros

•    ADB$$PRM ADBCUST
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19182

     UP14/06/28 P F406

• RB10 PSY UI19183

     UP14/06/28 P F406

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.