Symptom
DB2diag.log contains entries like the following
2017-09-05-12.52.05.980457+330 E581600A1137 LEVEL: Error (OS)
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
CALLED : OS, -, open
OSERR : EACCES (13) "Permission denied"
DATA #1 : Codepath, 8 bytes
DATA #2 : File name, 12 bytes
DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
SQLO_REVISE, SQLO_READWRITE, SQLO_EXCLUSIVE, SQLO_WRITETHRU
DATA #4 : Hex integer, 4 bytes
DATA #5 : signed integer, 4 bytes
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.
2024-03-20-12.37.30.892891+330 I61651910A3989 LEVEL: Error (OS)
PID : 000000000 TID : 0000 PROC : db2sysc 0
INSTANCE: db2<sid> NODE : 000 DB : <SID
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, open
OSERR : EACCES (13) "Permission denied"
DATA #1 : String, 150 bytes
A total of 2 analysis will be performed :
- User info
- Path access permission
Target file = /db2/<SID>/log_dir/NODE0000/LOGSTREAM0000/S0XXXXX.LOG
DATA #2 : String, 184 bytes
Real user ID of current process =
Effective user ID of current process =
Real group ID of current process =
Effective group ID of current process =
DATA #3 : String, 41 bytes
current sbrk(0) value: 0x0000000110ad4600
DATA #4 : String, 298 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
<UID>:<GID>:<permissions> (subdirectories)
0:0:755 (db2)
206:204:755 (SID)
206:204:755 (log_dir)
206:204:750 (NODE0000)
206:204:750 (LOGSTREAM0000)
0:0:644 (S0XXXXX.LOG)
Read more...
Environment
Db2 IBM
Product
Keywords
ossLogSysRC + 0x9C, log_dir, log file, /db2, upgrade, db2start, db2diag.log , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.