IBM Operations Analytics - Log Analysis, Version 1.3.2

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:

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.admin.trb.doc/doc/c0020815.html

The format for DB2 v9.7 log files is documented in:

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.trb.doc/doc/c0020815.html



Feedback