home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC75885 Status: Closed

"AUD0022N THE AUDIT LOG FILE IS CORRUPTED" DUE TO RUNNING DB2SE T
FROM PRE-FIXPAK 6 AGAINST FIXPACK 6 OR HIGHER (OR VICE VERSA)

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
The audit log file can become corrupt if the pre-Fixpak 6 
version of db2set is ran against against an instance that is at 
Fixpack 6 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 6 or higher 
and one is at Fixpak 5 or lower. 
2) Configure the Fixpak 6 instance to do instance auditing on 
SYSADMIN category 
3) From the Fixpak 5 instance, set DB2INSTANCE to point to the 
Fixpak 6 instance 
4) From Fixpak 5, run db2set. Because DB2INSTANCE is pointing to 
the Fixpak 6 instance, db2set will read the audit config from 
Fixpak 6 and write to the audit log in Fixpak 6. Note the Fixpak 
5 db2set is running, not Fixpak 6 
5) The Fixpak 6 audit log will be corrupted as a result.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* "AUD0022N  THE AUDIT LOG FILE IS CORRUPTED" DUE TO RUNNING   * 
* DB2SET FROM PRE-FIXPAK 6 AGAINST FIXPACK 6 OR HIGHER (OR     * 
* VICE VERSA)                                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 9                        * 
****************************************************************
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.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 9.5 Fix Pack 9
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC76025 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.04.2011
22.03.2012
22.03.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList