DB2 event monitor for statements

News Site news RSS

Latest articles New articles RSS

Latest news from Twitter Follow Secretkeeper4 and www.svesoftware.com on Twitter

DB2 event monitor for statements

Enabling monitor

db2> create event monitor stmon for statements write to file '/tmp'
db2> set event monitor stmon state=1

... make some queries meanwhile ...

db2> set event monitor stmon state=0
db2> terminate

Analyze logs:

db2evmon -path /tmp > ltrace.txt