DB2 FOR LUW / DB2FORLUW / 970 - DB2

There is a coding logic problem wherein if a file sharing 
violation is encountered (as in something external to DB2 
holding a lock on the db2audit file), our attempt to update th 
audit header will fail as the current code closes the file 
before our the audit header is written. Symptoms of this probl 
are: 
1. A .bk duplicate of the db2audit file will be in the audit l 
path. Both the .bk file and source audit file will contain a 
header with SQLEX_AUDIT_ARCHIVE_STATUS_T bFileArchiveStatus = 
SQLEX_AUDIT_ARCHIVE_START in them. 
2. The db2diag.log will contain the following: 
 
2009-07-28-12.01.36.814000+600 I10320966F587      LEVEL: Sever 
PID     : 5032                 TID  : 5508        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000 
APPHDL  : 0-12201              APPID: *LOCAL.DB2.090728020133 
AUTHID  : CIFADMIN 
EDUID   : 5508                 EDUNAME: db2agent (instance) 0 
FUNCTION: DB2 UDB, bsu security, sqlexDb2auditArchiveRename, 
probe:450 
CALLED  : DB2 UDB, bsu security, sqlexUpdateAuditLogHeader 
RETCODE : ZRC=0x870F0025=-2029060059=SQLO_INVH "invalid file 
handle" 
          DIA8534C An invalid file handle was encountered. 
 
 
2009-07-28-12.01.36.830000+600 I10321555F1222     LEVEL: Error 
PID     : 5032                 TID  : 5508        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000 
APPHDL  : 0-12201              APPID: *LOCAL.DB2.090728020133 
AUTHID  : CIFADMIN 
EDUID   : 5508                 EDUNAME: db2agent (instance) 0 
FUNCTION: DB2 UDB, bsu security, sqlexDb2auditArchiveRename, 
probe:400 
RETCODE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing 
violation." 
          DIA8519C A file sharing violation has occurred, 
filename was "". 
DATA #1 : Hexdump, 118 bytes 
0x000000000EC53F50 : 433A 5C44 4F43 554D 457E 315C 414C 4C55 
C:\DOCUME~1\ALLU 
0x000000000EC53F60 : 5345 7E31 5C41 5050 4C49 437E 315C 4942 
SE~1\APPLIC~1\IB 
0x000000000EC53F70 : 4D5C 4442 325C 4442 3243 4F50 5931 5C44 
M\DB2\DB2COPY1\D 
0x000000000EC53F80 : 4232 5C73 6563 7572 6974 795C 6175 6469 
B2\security\audi 
0x000000000EC53F90 : 7464 6174 615C 6462 3261 7564 6974 2E64 
tdata\db2audit.d 
0x000000000EC53FA0 : 622E 504F 5254 414C 2E6C 6F67 2E30 2E32 
b.PORTAL.log.0.2 
0x000000000EC53FB0 : 3030 3930 3732 3831 3230 3133 3337 3230 
0090728120133720 
0x000000000EC53FC0 : 3030 302E 626B 
000.bk

Close

- Stop DB2 
- Remove the offending audit log 
- Start DB2

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

Close

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.03.2010
30.06.2010
30.06.2010