PH65207: MESSAGE IBM0441W IS REPORTED WHEN THE REVOKE IMPACT REPORT IS GENERATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unexpected message IBM0441W for ONCODE 150 is reported when
  the revoke impact report is generated for the revoking SYSADM
  privilege from the user that has the view. This view references
  the table that is generated from the other user's table
  function. The execution of this table function is depending on
  SYSADM privilege of the user.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use the revoke impact report             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message IBM0441W for ONCODE 150 is      *
  *                      reported when the revoke impact report  *
  *                      is generated.                           *
  ****************************************************************
  Message IBM0441W for ONCODE 150 is reported unexpectedly
  when the revoke impact report is generated for revoking an
  administrative authority or EXECUTE privilege from the view
  owner. This view references the table that is generated from the
  table function. The execution of this table function depends on
  an administrative authority or EXECUTE privilege that is being
  revoked from the user.
  
  Sample of the message:
  IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
  
  Keywords: MSGIBM0441W ONCODE150
  

Problem conclusion

• The problem has been fixed.
  The following warning is displayed on the panel ADB2RIP instead
  of message IBM0441W.
  
  Can't revoke EXECUTE on <qualifier B>.<table function name>.
  <qualifier A>.<view name> depends on it.
  

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:

  UO03138

Modules/Macros

• ADBRIP9
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO03138

     UP25/05/14 I 1000

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.