每天一条DB2命令-037

每天一条DB2命令-037
#收集快照脚本,db2_snap.sh
db2 "update monitor switches using bufferpool on lock on sort on statement on table on timestamp on uow on"
db2 -v reset monitor all
sleep 60
db2 -v get snapshot for dbm > out_file
db2 -v get snapshot for all on dbname >> out_file
db2 "update monitor switches using bufferpool off lock off sort off statement off table off timestamp off uow off"
db2 terminate