|
Problem IT05852
|
Status: Closed |
GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
User issued GRANT / REVOKE statement on HADR primary database
and could see it's replicated to HADR standby side by querying
system catalog tables. But running the SQL on standby database
still encountered authority issue such as SQL0551N, actually it
should not. The problem is the granted or revoked privilege did
not take effect in catalog cache immediately on standby side. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users who use db2 v10.1 HADR *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 v10.1 fp5 or above *
**************************************************************** |
| Local Fix: |
deactivate / activate standby database to reload the data into
catalog cache. |
| Solution |
The problem is first fixed in db2 v10.1 fp5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.12.2014
15.07.2015
15.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
