Detailed steps for DB2 database performance monitoring

DB2 databasePerformance monitoring is another leap in the functionality of DB2 databases, marking the development of DB2 databases. Master the specific steps of DB2 database performance monitoring to Improve the Performance Monitoring of DB2 databases.

To monitor the performance of a DB2 database, follow these steps:

1: Create an SQL statement Monitor

Db2 create event monitor statmon for statements

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

2: create a directory

Md C: \ IBM \ butone \ statmon

3: Start the monitor

Db2 set event monitor statmon state 1

4: Execute the task

Do some job ....

5. finished output

Db2 flush event monitor statmon buffer

6. Disable the monitor.

Db2 set event monitor statmon state 0

7. format the output.

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

Note: Check the execution time of SQL statements in statmon. log.
The specific steps to monitor the performance of these DB2 databases are the most basic operations of the DB2 database. This is very important for beginners. Only after these basic steps can they be further explored, then we will study the DB2 database at a deeper level to better understand the knowledge of the DB2 database.