PK56884: WARNING MESSAGE REGARDING DROPPED SYNONYM AND ALIAS POPS UP EVEN WHEN YES IS SPECIFIED TO REPORT THEM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using DB2 Administration Tool, when generating a Revoke
  Impact Report for a user with SYSADM authority and YES is
  specified to Report Dropped Synonyms and Aliases, a warning
  still comes up that you have elected not to have dropped
  synonyms and aliases reported.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool using       *
  *                 the Revoke Impact Report for any             *
  *                 authorization except Storage Group.          *
  *                 This includes database, distinct type,       *
  *                 function, schema, package, collection,       *
  *                 stored procedure, plan, sequence,            *
  *                 buffer pool, tablespace, table and           *
  *                 system authorizations.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Even though the user specified Y for    *
  *                      Report Dropped Synonyms & Aliases       *
  *                      this value is ignored and N is used.    *
  *                      This results in message:                *
  *                      WARNING - You elected not to have       *
  *                      dropped Synonyms and Aliases reported.  *
  *                      There may be some dropped Synonyms or   *
  *                      Aliases that are not shown here.        *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Various authorization panels incorrectly set the control
  variable to a value of N when it should be a Y.
  

Problem conclusion

• The problem has been fixed.
  

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

•    ADB2RD   ADB2RE   ADB2RF   ADB2RH   ADB2RK
  ADB2RL   ADB2RO   ADB2RP   ADB2RQ   ADB2RR   ADB2RS   ADB2RT
  ADB2RZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK35275

     UP08/04/16 P F804

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.