DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

When using DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON, instance must 
be restarted before DBADM auth takes effect.

Reatart the instance ( db2stop / db2start)

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
 

First fixed in DB2 Version 9.7 Fix Pack 5

Reatart the instance ( db2stop / db2start)

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.05.2011
09.12.2011
09.12.2011

9.7.FP5