DB2 - Problem description
Problem IC76330 | Status: Closed |
WHEN USING DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON, INSTANCE MUST BE | |
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 | |
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 |