DB2數據庫性能監控的具體步驟:
1:創建sql語句的監視器
db2 create event monitor statmon for statements
write to file ''C:\IBM\butone\statmon''"
2:創建目錄
md C:\IBM\butone\statmon
3:啟動監視器
db2 set event monitor statmon state 1
4:執行任務
do some job to ....
5:完成輸出
db2 flush event monitor statmon buffer
6:關閉監視器