DB2性能测试监控UnixShell脚本

#! /usr/bin/sh
#监控间隔时间
interval=$1
#监控总次数
sum=$2

#取时间
nmon_time=`date +%Y%m%d%H%M%S`
#以系统当前时间创建目录，并将本次数据库监控结果放入此目录
mkdir /home/trace/cuichengyao/db2log/${nmon_time};chmod 777 /home/trace/cuichengyao/db2log/${nmon_time}

echo "开始DB2数据库监控，监控时间：${nmon_time}，监控时间间隔：${interval}秒，监控总次数：${sum}次"
sleep 5
#set db2 path
#安装目录
#export db2_install_path='/db2home/db2inst1/sqllib/bin'
export db2_install_path='/home/db2inst4/sqllib/bin'

#set monitor log path
#日志目录
#export monitor_log_path='/home/slsadmin/test/log'
#exprot monitor_log_path='/home/trace/cuichengyao/db2log/${nmon_time}'

#set database name
#数据库名称
export database_name='EBANKMC'

#启动监控
${db2_install_path}/db2 update dbm cfg using dft_mon_stmt on 

${db2_install_path}/db2 get monitor switches

${db2_install_path}/db2 update monitor switches using bufferpool on lock on sort on statement on table on uow on

#连接数据库
${db2_install_path}/db2 connect to ${database_name} user trace using trace123456

count=1
while(($count<=sum))
do

#监控数据库管理配置
echo "********************第{$count}次数据库管理配置数据收集********************"
${db2_install_path}/db2 get snapshot for database manager >>/home/trace/cuichengyao/db2log/${nmon_time}/dbmcfg${nmon_time}.log

#监控数据库配置
echo "********************第{$count}次数据库配置数据收集********************"
${db2_install_path}/db2 get snapshot for database on ${database_name} >>/home/trace/cuichengyao/db2log/${nmon_time}/dbcfg${nmon_time}.log

#监控表
echo "********************第{$count}次表数据收集********************"
${db2_install_path}/db2 get snapshot for tables on ${database_name} >>/home/trace/cuichengyao/db2log/${nmon_time}/tabtrc${nmon_time}.log
#${db2_install_path}/echo "*******************************************">>/home/trace/cuichengyao/db2log/${nmon_time}/tabtrc${nmon_time}.log

#监控锁
echo "********************第{$count}次锁数据收集********************"
${db2_install_path}/db2 get snapshot for locks on ${database_name} >>/home/trace/cuichengyao/db2log/${nmon_time}/locktrc${nmon_time}.log
#${db2_install_path}/echo "******************************************">>/home/trace/cuichengyao/db2log/${nmon_time}/locktrc${nmon_time}.log

#监控表空间