#打开监控器
db2 update monitor switches using statement on>>1.log
db2 update monitor switches using BUFFERPOOL on>>1.log
db2 update monitor switches using LOCK on>>1.log
db2 update monitor switches using SORT on>>1.log
db2 update monitor switches using TABLE on>>1.log
db2 update monitor switches using UOW on>>1.log
#执行脚本
db2 get snapshot for dynamic sql on test > "E:\快照信息\kzxx\dysqlstatus.log"
db2 get snapshot for db on test > "E:\快照信息\kzxx\databasestatus.log"
db2 get snapshot for tablespaces on test > "E:\快照信息\kzxx\tablespacestatus.log"
db2 get snapshot for bufferpools on test> "E:\快照信息\kzxx\bufferpools.log"
db2 get snapshot for tables on test > "E:\快照信息\kzxx\tables.log"
db2 get snapshot for applications on test > "E:\快照信息\kzxx\applications.log"
db2 get snapshot for dbm > "E:\快照信息\kzxx\dbm.log"
db2 get snapshot for locks on test > "E:\快照信息\kzxx\locks.log"
#关闭监控器
db2 update monitor switches using statement off>>1.log
db2 update monitor switches using BUFFERPOOL off>>1.log
db2 update monitor switches using LOCK off>>1.log
db2 update monitor switches using SORT off>>1.log
db2 update monitor switches using TABLE off>>1.log
db2 update monitor switches using UOW off>>1.log