DB2 SQL Event Monitor

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