|
Problem IC66984
|
Status: Closed |
FILE SHARING VIOLATION (AS IN SOMETHING EXTERNAL TO DB2 HOLDING A LOCK ON WINDOWS FOR THE DB2AUDIT FILE) |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
Close |
| Local Fix: |
- Stop DB2
- Remove the offending audit log
- Start DB2 |
| available fix packs: |
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
|
| Solution |
Close |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.03.2010
30.06.2010
30.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
