DB2 FOR LUW / DB2FORLUW / 970 - DB2

The ADMIN_REVALIDATE_DB_OBJECTS uses the package REVALH04 and 
dynamically 
prepares the statement to drive the revalidation: 
 
Since it's a dynamic prepare, and the package REVALH04 has 
DYNANMICRULES=B, 
we use the binder  of REVALH04 for authentication.  The binder 
of REVALH04 
is usually the database creator who would normally holds 
DATAACCESS 
authority. 
Therefore if  the ID  that created the database no longer has 
DATAACCESS 
 the command  db2  CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS 
('procedure','<SCHEMA>', '<NAME>')  will fail with -511 
 
Apar will changed owner to SYSIBM since REVAL04 is a system 
package

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 9                            * 
****************************************************************

--  Grant DATAACCESS to user ID or 
--  Drop package NULLID.REVALH04 and have a user with DATAACCESS 
authority 
execute: 
 
        CALL 
SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('none',null,null) 
 
  this will rebind the package and make this user the new OWNER, 
BINDER and 
DEFINER of REVALH04.  The first arg 'none' prevents any actual 
revalidation 
from taking place.  You can change the args to whatever you 
want, the first 
invocation of the procedure is just to drive a rebind of the 
dropped 
package REVALH04.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in Version 9.7 Fix Pack 9

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.05.2013
10.03.2014
10.03.2014

9.7.FP9