PI53835: WORKLOAD MANAGER/WLM REQUIREMENTS FOR THE DB2 ADMINISTRATION TOO L FOR Z/OS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The DB2 Administration Tool for z/OS does not provide a WLM
  example nor document what the specifications should be for a
  WLM environment to execute various stored procedures used by
  functions such as multi target change or reverse engineering.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 and IBM Tools Customizer for z/OS.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      does not describe its requirements      *
  *                      for or provide a procedure for          *
  *                      the Work Load Manager (WLM)             *
  *                      specifications that should be used      *
  *                      for a WLM environment to execute        *
  *                      various DB2 Admin stored procedures     *
  *                      provided by functions such as           *
  *                      multi-target change management          *
  *                      or reverse engineering.                 *
  *                                                              *
  *                      This APAR provides an optional          *
  *                      customization task/step in the DB2      *
  *                      Admin customization process using       *
  *                      IBM Tools Customizer for z/OS.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS does not describe its
  requirements for or does not provide a procedure for the
  Work Load Manager (WLM) specifications that should be used
  for a WLM environment to execute various DB2 Admin stored
  procedures provided by functions such as multi-target change
  management or reverse engineering.
  
  This APAR provides an optional customization task/step in
  the DB2 Admin customization process using IBM Tools
  Customizer for z/OS.
  

Problem conclusion

Temporary fix

Comments

• After applying this APAR, if you want to create a WLM
  procedure to be used by the stored procedures provided in
  DB2 Admin, follow the instructions below, otherwise, no
  action is needed.
  
  Instructions:
  
  1. Using IBM Tools Customizer for z/OS, navigate to panel
  CCQPWRK 'Customizer Workplace' and issue line command 'E -
  Edit' against each DB2 subsystem, and customize the value
  of parameters 'WLM Environment Proc Name' and 'WLM
  Environment NUMTCB' according to the needs of your
  environment.
  
  2. Navigate back to panel CCQPWRK 'Customizer Workplace',
  issue line command 'E - Edit' against 'Product parameters',
  then on panel CCQPPRD 'Product Parameters', select the task
  'Create the WLM address space'.
  
  3. Navigate back to panel CCQPWRK 'Customizer Workplace'
  and issue line command 'G - Generate' to re-generate the
  customization jobs.
  
  4. Review and submit job template ADBCUST 'General
  Customization' and ADBWLMP 'Create the WLM address
  space'  to register the WLM PROC name and WLM NUMTCB
  into ADBTPARM and create the sample WLM procedure.
  Follow the instructions in the generated WLM procedure
  to setup the WLM environment.
  
  The DB2 Administration Tool for z/OS User's Guide contains
  the following instructions for setting up stored procedures
  used by multi-target change and reverse engineering:
  
  Mutli-target changes:
  Version 11, Release 1: http://ibm.biz/BdHUMT
  Version 11, Release 2:http://ibm.biz/BdHUMk
  
  Optional: Define Reverse Engineering stored procedure
  for CC/390:
  Version 11, Release 1:  http://ibm.biz/BdHUMt
  Version 11, Release 2: http://ibm.biz/BdHUM6
  
  Optional: Enabling DB2 Admin distributed support
  Version 11, Release 1: http://ibm.biz/BdHUTQ
  Version 11, Release 2: http://ibm.biz/BdHUT3
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI35493 UI35494

Modules/Macros

•    ADB$$PRM ADB$$SEQ ADBCUST  ADBWLMP  ADB2CUST
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI35493

     UP16/02/20 P F602

• RB20 PSY UI35494

     UP16/02/20 P F602

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.