PI61111: DB2 ADMIN TOOL AFTER CUSTOMIZING ADMIN WLM ENVIRONMENT, ALTER STATEMENTS NOT GENERATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying APAR PI53835 and  performing HOLD actions to
  implement a WLM environment to be called  exclusively by the
  Admin / OC Tool stored procedures, the generated customization
  jobs do not provided ALTER statements for previously installed
  Admin/OC stored procedures.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS via IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Two issues related to DB2               *
  *                      Administration Tool for z/OS            *
  *                      customization are addressed:            *
  *                                                              *
  *                      Issue 1:                                *
  *                      User not able to alter the WLM          *
  *                      environment used by the DB2             *
  *                      Admin Tool stored procedures            *
  *                      which was specified by a                *
  *                      previous customization.                 *
  *                                                              *
  *                      Issue 2:                                *
  *                      An invalid DSN specification of         *
  *                      the DD card SYSUT2 in the generated     *
  *                      customization job ADBWLMP.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Two issues related to DB2 Administration Tool for z/OS
  customization are addressed:
  
  Issue 1:
  The customization process of DB2 Administration Tool for
  z/OS did not provide to the user the capability to alter the
  WLM environment used by the DB2 Admin Tool stored
  procedures which was specified by the previous
  customization.
  
  Issue 2:
  An invalid DSN specification of the DD card SYSUT2 in
  the generated customization job ADBWLMP when the
  data set name specified by option 'Admin Tool PROCLIB' on
  panel CCQPPRD 'Product Parameters' contains quotes.
  

Problem conclusion

• Problems have been resolved.
  
  The customization job ADBSETUP has been modified by adding
  the following ALTER statement for the product used stored
  procedures ADB2RCP, ADB2RE, ADBCRSP and ADBCRSU:
  
  ALTER PROCEDURE <proc_schema>.<proc_name>
  WLM ENVIRONMENT <wlm_name>;
  
  For users who have previously performed DB2 Admin Tool
  customization and would like to change the WLM environment
  currently being used by the product stored procedures, please
  follow the ++HOLD instructions.
  
  For users running the customization of the product for the
  first time, no action is needed.
  

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:

  UI38218 UI38219

Modules/Macros

•    ADBSETUP ADBWLMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI38218

     UP16/05/31 P F605

• RB20 PSY UI38219

     UP16/05/31 P F605

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.