How to read db2detaileventlock event monitor trace file

14 March,2015 by Jack Vamvas

Question: When I try to view the *.evt file in $DBHOME/db2event/db2detaildeadlock it looks like  binary. I’d like to be able to read the details in human readable format. Is there a DB2 utility  to format the event monitor trace file data?

Answer: Yes,  there is a DB2 utility called db2evmon. This utility formats the even monitor file.  Here is a an example of how to configure and execute the db2evmon  event monitor utility.In this example I'm viewing the file using the vi utility. I normally use vi to read text files on Linux.

If reading the output file on Windows , use whatever program you'd read a text file - for example Notepad or Wordpad.

 

#Create the output on from the event monitor trace file
db2evmon -path /db_home/db2event/db2detaildeadlock > /tmp/filtered.out 
# Read the events 
vi /tmp/filtered.out

 

A typical reason you may want to analyse the event monitor trace file is when there's a  SQL0911N Reason Code 68 The current transaction has been rolled back because of a deadlock or timeout in the db2diag.log file.


Read More on deadlocks

How to monitor a deadlock in DB2 - DBA DB2

SQL0911N Reason Code 68 The current transaction has been rolled back because of a deadlock or timeout

DB2 - Drop the DB2DETAILDEADLOCK event monitor - DBA DB2

Trace sql statements in DB2 database - DBA DB2

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to read db2detaileventlock event monitor trace file

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright