PH01280: DB2 ADMIN TOOL - REVOKE SYSADM, CASCADE NO, REVOKE IMPACT YES NO OBJECTS SHOWN EVEN WHEN OBJECTS ARE IMPACTED ADB2RZ

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using panel ADB2RZ to revoke a privilege (such as SYSADM),
  with 'cascade revoke' set to NO and 'report revoke impact' set
  to YES, the impact report does not list packages  and views and
  other objects, even though these objects may be dropped
  or invalidated when the privilege is revoked.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS who use the revoke impact function.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using panel ADB2RZ,                *
  *                      to revoke a SYSADM with cascade         *
  *                      revoke set to YES and report revoke     *
  *                      Impact set to YES,                      *
  *                      packages and views and other            *
  *                      objects are shown,                      *
  *                                                              *
  *                      With cascade set to NO, no objects      *
  *                      are shown. but when the revoke is       *
  *                      done, views are missing and             *
  *                      packages are not valid.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In revoke impact report with cascade NO, the views
  and packages are not shown as to be affected.
  However, after revoke, the views are dropped and
  packages are invalidated, the report should have
  shown those object as being impacted by the revoke.
  

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:

Modules/Macros

•    ADBRIP9
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.