Posted on 2008-07-31 09:09
默認為零 閱讀(274)
評論(0) 編輯 收藏 所屬分類:
技術
##使用eventor收集數據 ====
##設置工作參數
DB=dbname
WORKDIR=/home/event/
db2 connect to $DB
##創建event monitor
db2 "create event monitor evsql for statements write to file '$WORKDIR' replace"
##收集數據
##!/usr/bin/ksh
TIMESTAMP=`date +%H%M`
db2 connect to $DB
db2 set event monitor evsql state=1
##設置監控的時間，單位是秒
sleep 20
db2 set event monitor evsql state=0
db2evmon -db $DB -evm evsql > evsql.$DB.$TIMESTAMP.txt
#刪除event monitor
db2 connect to $DB
db2 drop event monitor evsql
#result phase sample:
grep "Exec Time" evsql.$DB.$TIMESTAMP.txt |awk '{print $3}'|uniq|sort >sql.txt