|
Problem IC72403
|
Status: Geschlossen |
AUDIT POLICY STILL ASSOCIATES WITH OLD DATABASE NAME AFTER THE DATABASE IS RESTORED IN A NEW DATABASE NAME. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
After performing a redirect restore on the database, with a new
name, from a backup on an instance with db2audit running on,
user cannot remove the policy auditing the new database. The
view SYSCAT.AUDITUSE shows the association between the audit
policy and the old database name, which is recorded in the
OBJECTNAME column.
Remove the audit policy will result an error:
SQL0478N DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object
type "AUDIT POLICY" cannot be processed because there is an
object "old_db", of type "DATABASE", which depends on it.
SQLSTATE=42893 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 audit users *
****************************************************************
* PROBLEM DESCRIPTION: *
* After performing a redirect restore on the database, with a *
* new *
* name, from a backup on an instance with db2audit running on, *
* *
* user cannot remove the policy auditing the new database. The *
* *
* view SYSCAT.AUDITUSE shows the association between the audit *
* *
* policy and the old database name, which is recorded in the *
* *
* OBJECTNAME column. *
* *
* *
* *
* Remove the audit policy will result an error: *
* *
* SQL0478N DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object *
* *
* type "AUDIT POLICY" cannot be processed because there is an *
* *
* object "old_db", of type "DATABASE", which depends on it. *
* *
* SQLSTATE=42893 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 FP4 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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
|
| Lösung |
Problem was first fixed in Version v9.7 Fix Pack 4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.11.2010
02.05.2011
02.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
