from 	SESSION.JOURNAL t join SESSION.DETAIL t0 on t.id=t0.ID_JOURNAL

DECLARE GLOBAL TEMPORARY TABLE SESSION.JOURNAL (ID NOT NULL) 	WITH REPLACE ON COMMIT DELETE ROWS NOT LOGGED;

db2pd -db mydb -tcbstats nocatalog file=myfile.txt

AUTOCOMMIT OFF

CREATE GLOBAL TEMPORARY TABLE TEMP13
     (TMP1   CHAR(3)        NOT NULL,
      TMP2   VARCHAR(24) NOT NULL); 
COMMIT;	  
	  insert into TEMP13 VALUES('WWW','RRRRRRRRRRRRRRRR');
	  SELECT * FROM TEMP13;
COMMIT;
	  SELECT * FROM TEMP13;
DROP TABLE TEMP13;
COMMIT;

CREATE EVENT MONITOR STMT_IBMUSER FOR STATEMENTS
WHERE AUTH_ID='USERTST'
WRITE TO TABLE
  CONNHEADER (TABLE USERTST.STMT_IBMUSER_CONN IN USERSPACE1)
, STMT (TABLE USERTST.STMT_IBMUSER_STMT IN USERSPACE1
);

SET EVENT MONITOR STMT_IBMUSER STATE 1;

CREATE GLOBAL TEMPORARY TABLE TEMP13
     (TMP1   CHAR(3)     NOT NULL,
      TMP2 VARCHAR(36) NOT NULL); 
  
	  insert into TEMP13 VALUES('WWW','RRRRRRRRRRRRRRRR');

select ROWS_READ , ROWS_WRITTEN
  from "USERTST"."STMT_IBMUSER_STMT" WHERE "STMT_TEXT" like '%insert%';
  
DROP TABLE TEMP13;

select m.TABNAME, m.ROWS_READ, m.ROWS_INSERTED, m.ROWS_UPDATED, m.ROWS_DELETED
from 
  table (values 'JOURNAL', 'DETAIL') t(tabname)
, table(mon_get_table('SESSION', t.tabname, -1)) m