DB2 performance monitoring

Step 1: Create an SQL statement Monitor

 

DB2 create event monitor statmon for statements write to file 'C:/IBM/butone/statmon '"

 

Step 2: create a directory

 

Md c:/IBM/butone/statmon

 

Step 3: Start the monitor

 

DB2 set event monitor statmon state 1

 

Step 4: Execute the task

 

Do some job ....

 

Step 5: complete the output

 

DB2 flush event monitor statmon Buffer

 

Step 6: Disable the monitor

 

DB2 set event monitor statmon state 0

 

Step 7: format the output

 

Db2evmon-path C:/IBM/butone/statmon> statmon. Log

 

 

View the execution time of SQL statements in statmon. Log