Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC92309 Status: Closed

ADMIN_REVALIDATE_DB_OBJECTS WILL FAIL WITH -551 IF ID USED TO CREATE DB NO
LONGER HAS DATAACCESS AUTHORITY

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 9                            * 
****************************************************************
Local Fix:
--  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.
available fix packs:
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

Solution
First fixed in Version 9.7 Fix Pack 9
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.05.2013
10.03.2014
10.03.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.