Posted on 2008-07-31 09:09
默認(rèn)為零 閱讀(274)
評(píng)論(0) 編輯 收藏 所屬分類:
技術(shù)
##使用eventor收集數(shù)據(jù) ====
##設(shè)置工作參數(shù)
DB=dbname
WORKDIR=/home/event/
db2 connect to $DB
##創(chuàng)建event monitor
db2 "create event monitor evsql for statements write to file '$WORKDIR' replace"
##收集數(shù)據(jù)
##!/usr/bin/ksh
TIMESTAMP=`date +%H%M`
db2 connect to $DB
db2 set event monitor evsql state=1
##設(shè)置監(jiān)控的時(shí)間，單位是秒
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