SELECT STMT_TEXT FROM TABLE (SNAPSHOT_STATEMENT('',-1)) ;

CALL TEST_PROC('TEST')

CALL TEST_PROC(?)

CREATE EVENT MONITOR DB2ACTIVITIES
       FOR ACTIVITIES
       WRITE TO TABLE
       ACTIVITY (TABLE ACTIVITY_DB2ACTIVITIES
                 IN USERSPACE1
                 PCTDEACTIVATE 100),
       ACTIVITYMETRICS (TABLE ACTIVITYMETRICS_DB2ACTIVITIES
                        IN USERSPACE1
                        PCTDEACTIVATE 100),
       ACTIVITYSTMT (TABLE ACTIVITYSTMT_DB2ACTIVITIES
                     IN USERSPACE1
                     PCTDEACTIVATE 100),
       ACTIVITYVALS (TABLE ACTIVITYVALS_DB2ACTIVITIES
                     IN USERSPACE1
                     PCTDEACTIVATE 100),
       CONTROL (TABLE CONTROL_DB2ACTIVITIES
                IN USERSPACE1
                PCTDEACTIVATE 100)
       AUTOSTART;

....
String query = "CALL WLM_SET_CONN_ENV( NULL, '<collectactdata>WITH DETAILS AND VALUES</collectactdata>')";
executeQuery(connection, query);

String[] param = new String[2];
param[0] = "param0";
param[1] = "param1";

String storedProc = "CALL TEST_PROC(?, ?)";
CallableStatement callStat = connection.prepareCall(storedProc);
executePrepared(callStat, param);
....
query = "CALL WLM_SET_CONN_ENV(NULL, '<collectactdata>NONE</collectactdata>')";
executeQuery(connection, query)
....