DB2多次抓取快照脚本

#!/bin/ksh93
maxcount=10
intervalcount=1
sleeptime=120
if [ $# -eq 0 ] ; then
  echo "Usage snap.ksh "
  exit 1
fi

DB=$1
db2 terminate 2>&1
db2 connect to $DB
db2 reset monitor all
db2 update monitor switches using bufferpool on lock on sort on statement on table on uow on timestamp on
while (( intervalcount <=  maxcount )) ;
do
     datestamp=`date +"%Y%m%d%H%M"`
     db2 get snapshot for database manager > dbmsnap.${datestamp} 2>&1
     db2 get snapshot for database on $DB > $DB.dbsnap.${datestmap} 2>&1
     db2 get snapshot for applications on $DB > $DB.appsnap.${datestmap} 2>&1
     db2 get snapshot for tables on $DB > $DB.tablesnap.${datestmap} 2>&1
     db2 get snapshot for tablespaces on $DB > $DB.tbssnap.${datestmap} 2>&1
     db2 get snapshot for locks on $DB > $DB.locksnap.${datestmap} 2>&1
     db2 get snapshot for bufferpools on $DB > $DB.bufferpoolsnap.${datestmap} 2>&1
     db2 get snapshot for dynamic sql on $DB > $DB.dynsqlsnap.${datestmap} 2>&1
     ((intervalcount=intervalcount+1))
     sleep $sleeptime
done
db2 terminate

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22661144/viewspace-1477194/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22661144/viewspace-1477194/