|
Problem IC76025
|
Status: Closed |
"AUD0022N THE AUDIT LOG FILE IS CORRUPTED" DUE TO RUNNING DB2SE T FROM PRE-FIXPAK 2 AGAINST FIXPACK 2 OR HIGHER (OR VICE VERSA) |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The audit log file can become corrupt if the pre-Fixpak 2
version of db2set is ran against against an instance that is at
Fixpack 2 or higher (or vice versa). This also affects any
other commands that happen to run db2set as part of it's
processing (such as the db2ilist command).
The following sequence of commands is an example of how the
corruption may occur.
1) Two instances on the same box. One is on Fixpak 2 or higher
and one is at Fixpak 1 or lower.
2) Configure the Fixpak 2 instance to do instance auditing on
SYSADMIN category
3) From the Fixpak 1 instance, set DB2INSTANCE to point to the
Fixpak 2 instance
4) From Fixpak 1, run db2set. Because DB2INSTANCE is pointing to
the Fixpak 2 instance, db2set will read the audit config from
Fixpak 2 and write to the audit log in Fixpak 2. Note the Fixpak
1 db2set is running, not Fixpak 2
5) The Fixpak 2 audit log will be corrupted as a result. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users that have multiple copies of v9.7 at different Fixpack *
* levels *
****************************************************************
* PROBLEM DESCRIPTION: *
* "AUD0022N THE AUDIT LOG FILE IS CORRUPTED" DUE TO RUNNING *
* DB2SET FROM PRE-FIXPAK 2 AGAINST FIXPACK 2 OR HIGHER (OR *
* VICE VERSA) *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 Fixpack 5 *
**************************************************************** |
| Local Fix: |
Ensure the db2set command being ran is from the same Fixpack
version as the instance to avoid corrupting the audit log. |
| available fix packs: |
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 |
First fixed in DB2 v9.7 Fixpack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.04.2011
19.01.2012
19.01.2012 |
| 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
|
 |
