Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC72403 Status: Closed

AUDIT POLICY STILL ASSOCIATES WITH OLD DATABASE NAME AFTER THE DATABASE IS
RESTORED IN A NEW DATABASE NAME.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
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
Problem Summary:
**************************************************************** 
* 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:
available fix packs:
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

Solution
Problem was first fixed in Version v9.7 Fix Pack 4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.11.2010
02.05.2011
02.05.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP4
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.4 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.