DB2數(shù)據(jù)庫(kù)性能監(jiān)控的具體步驟:
1:創(chuàng)建sql語(yǔ)句的監(jiān)視器
db2 create event monitor statmon for statements
write to file 'C:\IBM\butone\statmon'"
2:創(chuàng)建目錄
md C:\IBM\butone\statmon
3:?jiǎn)?dòng)監(jiān)視器
db2 set event monitor statmon state 1
4:執(zhí)行任務(wù)
do some job to ....
5:完成輸出
db2 flush event monitor statmon buffer
6:關(guān)閉監(jiān)視器
db2 set event monitor statmon state 0
7:格式化輸出
db2evmon -path C:\IBM\butone\statmon > statmon.log
注:查看statmon.log中的sql語(yǔ)句的執(zhí)行時(shí)間
1:創(chuàng)建sql語(yǔ)句的監(jiān)視器
db2 create event monitor statmon for statements
write to file 'C:\IBM\butone\statmon'"
2:創(chuàng)建目錄
md C:\IBM\butone\statmon
3:?jiǎn)?dòng)監(jiān)視器
db2 set event monitor statmon state 1
4:執(zhí)行任務(wù)
do some job to ....
5:完成輸出
db2 flush event monitor statmon buffer
6:關(guān)閉監(jiān)視器
db2 set event monitor statmon state 0
7:格式化輸出
db2evmon -path C:\IBM\butone\statmon > statmon.log
注:查看statmon.log中的sql語(yǔ)句的執(zhí)行時(shí)間