Cacher is the code snippet organizer for pro developers

CREATE EVENT MONITOR ADILSONEVMON
   FOR STATEMENTS
   WRITE TO TABLE
   CONNHEADER (TABLE CONNHEADER_ADILSON
			 IN USERSPACE1
			 PCTDEACTIVATE 100),
   STMT (TABLE STMT_ADILSON
					IN USERSPACE1
					PCTDEACTIVATE 100),
   SUBSECTION (TABLE SUBSECTION_ADILSON
				 IN USERSPACE1
				 PCTDEACTIVATE 100),
   CONTROL (TABLE CONTROL_ADILSON
				 IN USERSPACE1
				 PCTDEACTIVATE 100)
   MANUALSTART;

CREATE EVENT MONITOR evstmts FOR STATEMENTS WRITE TO FILE '/home/db2inst1/arapozo/20180919-event-monitor/output' MANUALSTART;

CREATE EVENT MONITOR ADILSONEVMON
   FOR STATEMENTS
   WRITE TO TABLE
   STMT (TABLE STMT_ADILSON
					IN USERSPACE1
				 INCLUDES(AGENT_ID, APPL_ID, INT_ROWS_DELETED, INT_ROWS_INSERTED, INT_ROWS_UPDATED, SQLCODE, START_TIME, STOP_TIME, STMT_TEXT)),
   CONTROL (TABLE CONTROL_ADILSON
				 IN USERSPACE1)
   MANUALSTART;