I'm using DB2 v9.1.4 LUW. I want to read the event monitor logs for deadlocks. I'm not that familiar with this.

For example there are two files out in:
/db2syscat/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/

00000000.evt
db2event.ctl

Then I used the db2evmon command like this, to copy to a readable format:
db2evmon -path /db2syscat/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/ > /source/00000000.txt

Here is what is in the file:
--------------------------------------------------------------------------
EVENT LOG HEADER
Event Monitor name: DEADLOCK
Server Product ID: SQL09014
Version of event monitor data: 8
Byte order: BIG ENDIAN
Number of nodes in db2 instance: 1
Codepage of database: 1208
Territory code of database: 1
Server instance name: db2inst1
--------------------------------------------------------------------------

--------------------------------------------------------------------------
Database Name: PSFTPROD
Database Path: /db2_data/db2inst1/NODE0000/SQL00001/
First connection timestamp: 01/17/2010 19:19:20.120504
Event Monitor Start time: 01/21/2010 08:18:51.899592
--------------------------------------------------------------------------


I expected to see more information and details here.
I see this is a Header file, is there details or how to a view the details?
Or is there something I'm missing or need to do?

Could someone who is experienced with DB2 Event Monitors explain how this works and give me any information.

Thank you.


Carla Clark

Maybe you did not encounter any deadlocks?

Make sure you FLUSH EVENT MONITOR, otherwise recent events may not be present in the file.

Hi, we have a bunch of .evt files, it seems that the command db2evmon looks for the file named 00000000.EVT
How can I issue this command and have it point to a .evt file other than the 00000000.EVT file? If I specify a filename, It automatically appends the 00000000.EVT filename.

Thanks

db2evmon cannot read the event stream in the middle of it; it has to start from the beginning and will read all event files in sequence. Why do you think you need to read a file other than 00000000.EVT?

We will eventually see the following message
ADM2017C The Event Monitor "DB2DETAILDEADLOCK" has reached its file capacity.
Delete the files in the target directory
"G:\DB2QREP\NODE0000\SQL00002\DB2EVENT\db2detailde adlock" or move them to
another directory.

therefore we need to periodically remove .evt files from the directory.
This is why we are not starting at 0000

try db2evmon with -file parameter:
db2evmon -path <path> -file <number>

where <number> is the evt file number

Stop the event monitor before moving the files, restart it afterwards to begin a new set of files.

Thanks db2girl the -file option worked!