Skip to content

Instantly share code, notes, and snippets.

@auycro

auycro/DB2SqlMonitor.sql

Created April 4, 2014 01:46
Show Gist options
  • Save auycro/9966492 to your computer and use it in GitHub Desktop.
Save auycro/9966492 to your computer and use it in GitHub Desktop.
Download ZIP
DB2 SQL Event Monitor
Raw
DB2SqlMonitor.sql
--
update monitor switches using statement on ;
--Create Event Monitor
create event monitor ykrkmonapp for statements write to file 'd:/tmp';
--Set Event Monitor Active
set event monitor ykrkmonapp state=1 ;
--Drop Event Monitor
drop event monitor ykrkmonapp ;
-- Create Trace File From *evt [run in DB2CMD]
-- db2evmon -path d:/tmp > sqltrace.txt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment