WebSphere Message Brokers
File: an04110_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:33:12

Database logs

Databases write severe error and warning conditions to the local error log (syslog). Typically, databases also write errors to a database log file, such as the db2diag.log file on DB2.

You can open the db2diag.log file in a text editor.

The example below shows a typical entry from the db2diag.log file:

Jun 18 15:02:53 bluj DB2[46827]: DB2(db2inst1.000(1))oper_system_services sqlobeep(2)
 reports:(3) 
Jun 18 15:02:53 (4) bluj (5) DB2[46827(6)]: extra symptom string provided:(7) RIDS/sqlesysc_ 
Jun 18 15:02:53 bluj DB2[46827]:     data: (8)  54686973  20697320  616e2065  78616d70         
Jun 18 15:02:53 bluj DB2[46827]:     data:   6c65206f  66206c6f  67676564  20646174          
Jun 18 15:02:53 bluj DB2[46827]:     data:   61                                              
Jun 18 15:02:53 bluj DB2[46827]: 2 piece(s) of dump data provided... to file(9) /u/db2inst1/
Jun 18 15:02:53 bluj DB2[46827]:         1. 'DUMP EXAMPLE #1' has been dumped (10)
Jun 18 15:02:53 bluj DB2[46827]:         2. 'DUMP EXAMPLE #2' has been dumped

The bold numbers in the example show various items in the log file:

(1)
The instance name and node number
(2)
The reporting component and function
(3)
The probe ID and error and alert numbers
(4)
A time stamp for when the event occurred
(5)
The host name
(6)
The process ID of the reporting process. Use the ps command to view information about the process ID of the reporting process. For example, enter the following command to get information about the reporting process:
 ps -fu 46827
(7)
A symptom string that contains additional information about where and why the problem occurred
(8)
A hexadecimal dump of data that includes return codes and other information that can be interpreted by your IBM Support Center
(9)
Information about additional dump files. Larger structures and other binary data might be dumped to additional files. The name of the file is identified in the syslog file
(10)
An entry to identify a piece of dump data
Related tasks
Troubleshooting and support
Using logs
Related reference
Database facilities
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:33:12

an04110_ This topic's URL is: