|
Problem IT05852
|
Status: Geschlossen |
GRANT / REVOKE PRIVILEGE DID NOT TAKE EFFECT IN CATALOG CACHE IMMEDIATELY ON HADR STANDBY SIDE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| Lösung |
The problem is first fixed in db2 v10.1 fp5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.12.2014
15.07.2015
15.07.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.5
|
 |
