DB2 V7 SQL监控摘记
執行步驟0.連線DB
db2 "connect to DBName USER UserID USING Password"
1.在D:\AAA的目錄下建立sql的監聽器(只需做一次即可)
db2 create event monitor statmon for statements write to file 'D:\AAA'"
db2 drop event monitor statmon
2.啟動監聽器
db2 set event monitor statmon state 1
3.跑程式上的功能
4.完成輸出
db2 flush event monitor statmon buffer
5.關閉監聽器
db2 set event monitor statmon state 0
6.格式化輸出
db2evmon -path D:\AAA > statmon.log
7.斷線DB
db2 "disconnect DBName"
页:
[1]