PI57514: DB2 ADMIN TOOL ADD OPTION IN THE CUSTOMIZATION PHASE TO ALLOW THE USER TO MANAGE THE AUTHORIZATIONS ON THE CM OBJECTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Currently, Admin Tool does GRANT TO PUBLIC for Change
  Management Database.  This APAR will add an option in
  the customization phase to allow the user to manage the
  authorizations on the CM objects.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use the IBM Tools          *
  *                 Customizer for z/OS to perform               *
  *                 product customization.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: No way to allow the user to control     *
  *                      granting privileges on the Change       *
  *                      Management tables.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In the DB2 Administration Tool customization job ADBSETUP,
  the privileges of the Change Management tables are hard-coded
  as GRANT to PUBLIC.
  
  This APAR enhances the DB2 Administration Tool and DB2
  Object Comparison Tool customization process by providing
  the option to give the user control over granting privileges
  on the Change Management tables.
  

Problem conclusion

Temporary fix

Comments

• Problem has been resolved.
  
  The following option has been added to the 'Product
  Parameters: DB2 Admin Tool' panel under the 'Admin Tool
  Setup Task (Create and Upgrade)' section:
  
  GRANT privileges on CM objects . . . . .
  
  This option enables the user to specify what authorization
  IDs the privileges are granted to the Change Management
  tables. If "NONE" is specified, then GRANT statements
  will not be generated.
  

APAR Information

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

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

  UI37876 UI37877

Modules/Macros

•    ADB$$PRM ADBCUST  ADBSETUP ADB2CUST
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI37876

     UP16/05/19 P F605

• RB20 PSY UI37877

     UP16/05/19 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.