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.
SAP Knowledge Base Article - Preview