Troubleshooting
Problem
How to resolve messages which are related to file sharing violation.
Symptom
Similar messages will be reported in the db2diag.log
2012-01-30-13.51.55.003547-300 E1400056A1005 LEVEL: Error (OS)
PID : 5423224 TID : 5913 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB1
EDUID : 5913 EDUNAME: db2loggr (MYDB1) 0
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was
"".
CALLED : OS, -, open
OSERR : ETXTBSY (26) "Text file busy"
DATA #1 : Codepath, 8 bytes
4:8:12:13:36:37:63
DATA #2 : File name, 38 bytes
/db2/MYDB1/log_dir/NODE0000/S0007601.LOG
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_REVISE, SQLO_READONLY, SQLO_EXCLUSIVE
DATA #4 : Hex integer, 4 bytes
0x000001A0
DATA #5 : signed integer, 4 bytes
100
DATA #6 : signed integer, 4 bytes
0
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for
further self-diagnosis of this problem.
2012-01-30-13.51.58.016221-300 E1403021A519 LEVEL: Error
PID : 5423224 TID : 5913 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB1
EDUID : 5913 EDUNAME: db2loggr (MYDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgOrphanLogFile,
probe:900
MESSAGE : ADM1510W A file sharing violation has occurred while
accessing log file "S0007601.LOG". Another process may be using this file.
DB2 will try to delete it later.
2012-01-30-13.51.55.003547-300 E1400056A1005 LEVEL: Error (OS)
PID : 5423224 TID : 5913 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB1
EDUID : 5913 EDUNAME: db2loggr (MYDB1) 0
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was
"".
CALLED : OS, -, open
OSERR : ETXTBSY (26) "Text file busy"
DATA #1 : Codepath, 8 bytes
4:8:12:13:36:37:63
DATA #2 : File name, 38 bytes
/db2/MYDB1/log_dir/NODE0000/S0007601.LOG
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_REVISE, SQLO_READONLY, SQLO_EXCLUSIVE
DATA #4 : Hex integer, 4 bytes
0x000001A0
DATA #5 : signed integer, 4 bytes
100
DATA #6 : signed integer, 4 bytes
0
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for
further self-diagnosis of this problem.
2012-01-30-13.51.58.016221-300 E1403021A519 LEVEL: Error
PID : 5423224 TID : 5913 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB1
EDUID : 5913 EDUNAME: db2loggr (MYDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgOrphanLogFile,
probe:900
MESSAGE : ADM1510W A file sharing violation has occurred while
accessing log file "S0007601.LOG". Another process may be using this file.
DB2 will try to delete it later.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - db2diag.log","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg21580422