home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC76330 Status: Closed

WHEN USING DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON, INSTANCE MUST BE
RESTARTED BEFORE DBADM AUTH TAKES EFFECT

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When using DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON, instance must 
be restarted before DBADM auth takes effect. 
 
For Example: 
 
backup database sample on instance db2inst01 
restore database sample from the backup onto db2inst02 
 
Check the permission in sysdbauth for grantee db2inst02 
 
 db2 select grantor, grantee, dbadmauth, securitydmauth  from 
sysibm.sysdbauth where grantee='DB2INST02' 
 
GRANTOR   GRANTEE    DBADMAUTH SECURITYADMAUTH 
--------- ---------- --------- --------------- 
SYSIBM    DB2INST02  Y         Y 
 
 
Select or grant statement fails with SQL0551N 
 
db2 "select * from db2inst01.staff" 
SQL0551N  "DB2INST02" does not have the required 
authorization or privilege to 
perform operation "SELECT" on object "DB2INST01.STAFF". 
SQLSTATE=42501 
 
 
db2 "grant select on table db2inst01.staff to user user1" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0551N  "DB2INST02" does not have the required authorization 
or privilege to 
perform operation "GRANT" on object "DB@INST01.STAFF". 
SQLSTATE=42501 
 
 
After instance restart (db2stop / db2start) select and grant 
works fine.
Problem Summary:
When using DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON, instance must 
be restarted before DBADM auth takes effect.
Local Fix:
Reatart the instance ( db2stop / db2start)
available fix packs:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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 DB2 Version 9.7 Fix Pack 5
Workaround
Reatart the instance ( db2stop / db2start)
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.05.2011
09.12.2011
09.12.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList