Detailed steps to monitor the performance of IBM DB2 databases

DB2 the specific steps of database performance monitoring:

1: The monitor that creates the SQL statement

DB2 Create Event Monitor Statmon for statements

Write to file ' C:\IBM\butone\statmon ' \ '

2: Create a Table of contents

MD C:\IBM\butone\statmon

3: Start monitor

DB2 Set Event Monitor Statmon State 1

4: Perform the task

Do some job to ....

5: Complete the output

DB2 Flush Event Monitor Statmon buffer

6: Turn off the monitor

DB2 Set Event Monitor Statmon State 0

7: Format output

Db2evmon-path C:\IBM\butone\statmon > Statmon.log

Note: View the execution time of SQL statements in Statmon.log