PI64248: DB2 COMPARE TOOL PANEL GOC5 RUN SQLID AND OBJECT GRANTOR NOT WORKING AS DESCRIBED (V11.2 ONLY)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When 'Object Grantor' is also specified, it is ignored/not used
  as expected for the GRANT statements.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS and Object Comparison Tool              *
  *                 for z/OS who make changes to                 *
  *                 objects and the generated APPLY              *
  *                 jobs/Work Statement List (WSL)               *
  *                 contain GRANT statements.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALT, Compare or          *
  *                      Change Management function to           *
  *                      make change to objects with the         *
  *                      "Object Grantor" option specified,      *
  *                      the option was ignored/not used         *
  *                      as expected for the GRANT               *
  *                      statements.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT, Compare or Change Management function to
  make change to objects with the "Object Grantor" option
  specified, the option was ignored/not used as expected for
  the GRANT statements. For example, when a table with
  authorizations on it is dropped/recreated, and "Object
  Grantor" option on panel GOC5 "Generate Compare Jobs" is
  specified with a SQLID different from the original grantor,
  the original grantor was still used in the "SET CURRENT
  SQLID" statement generated prior to the GRANT statements
  instead of the one specified.
  

Problem conclusion

• The 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:

  UI41177

Modules/Macros

• ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI41177

     UP16/10/01 P F609

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.