kr153
6/23/2014 - 6:11 AM

DB2 Event Monitoring

DB2 Event Monitoring


TRUNCATE TABLE ADMINISTRATOR.STMT_TEST IMMEDIATE


SELECT * FROM ADMINISTRATOR.STMT_TEST


-----------------------------------
SELECT 
   STMT_TEXT, 
   CURSOR_NAME , 
   SYSTEM_CPU_TIME, 
    USER_CPU_TIME 
FROM 
    ADMINISTRATOR.STMT_TEST 
ORDER BY 
    SYSTEM_CPU_TIME DESC, 
   USER_CPU_TIME DESC
-------------------------------------