|
Problem IT02469
|
Status: Closed |
AUD0022N MAY BE REPORTED WHEN DB2AUDIT EXTRACTS CORRUPTED AUDIT LOG |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In effect of using the db2audit extract command, you get
AUD0022N The Audit Log File is corrupted.
[db2inst1@localhost logs]$ db2audit extract delasc delimiter !
from files ./db2audit.instance.log.0.<timestamp>
AUD0022N The Audit Log File is corrupted.
AUD0001N Operation failed.
It might be reported in the diaglog under LEVEL: Error
HOSTNAME: localhost.localdomain
FUNCTION: DB2 UDB, bsu security, sqlex_db2audit_main, probe:350
Reason:
The reason for the problem is the lack of thread level locking
for the db2acd process.
Audit log corruption may occur when multiple DB2 threads write
to the audit log file.
When multiple threads do this simultaneously, the file locking
mechanism doesn't provide thread level access control and this
may lead to corruption audit log records. The corruption might
take place when a multithreaded process db2acd writes audit log
record to the audit log file. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 10 or higher. *
**************************************************************** |
| Local Fix: |
|
| Solution |
Fixed in DB2 Version 9.7 Fix Pack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.06.2014
24.11.2014
24.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
