Log file formats
The basic formats of the DB2® log files are described here as a reference for users.
The basic format of db2diag.log file
is:
timestamp recordId LEVEL: level(source)
PID : pid TID : tid PROC : procName
INSTANCE: instance NODE : node DB : database
APPHDL : appHandle APPID: appID
AUTHID : authID
EDUID : eduID EDUNAME: engine dispatchable unit name
FUNCTION: prodName, compName, funcName, probe: probeNum
MESSAGE : messageID msgText
CALLED : prodName, compName, funcName OSERR: errorName (errno)
RETCODE : type=retCode errorDesc
ARG #N : typeTitle, typeName, size bytes
... argument ...
DATA #N : typeTitle, typeName, size bytes
... data ...
Only these fields are present in all log records.timestamp
timezone
recordID
level
pid
tid
FUNCTION
For more information about DB2 log file formats, see the following topic on the DB2 information centers:
The format for DB2 10.1 log files is documented in:
The format for DB2 v9.7 log files is documented in: