#-su db2inst1 //用db2用户登录
#db2 get monitor switches //查看监控开关状态
#db2 update monitor switches using STATEMENT ON //打开监控sql开关
#db2 update monitor switches using LOCK ON //打开锁监控开关
#db2 update monitor switches using SORT ON
#db2 update monitor switches using BUFFERPOOL ON
#db2 update monitor switches using UOW ON
#db2 update monitor switches using TABLE ON
#db2 update monitor switches using TIMESTAMP ON
//关闭监控开关
#db2 update monitor switches using STATEMENT OFF
#db2 update monitor switches using LOCK OFF
#db2 update monitor switches using SORT OFF
#db2 update monitor switches using BUFFERPOOL OFF
#db2 update monitor switches using UOW OFF
#db2 update monitor switches using TABLE OFF
#db2 update monitor switches using TIMESTAMP OFF
//输出分析日志文件
#db2 get snapshot for dynamic SQL on YPCDBL > /tmp/20100704statement.txt
#db2 get snapshot for locks on YPCDBL > /tmp/20100704lock.txt
#db2 get snapshot for BUFFERPOOLS on YPCDBL > /tmp/20100704BUFFERPOOLS.txt
#db2 get snapshot for APPLICATIONS on YPCDBL > /tmp/20100704APPLICATIONS.txt
#db2 get snapshot for tables on YPCDBL > /tmp/20100704tables.txt
#db2 get snapshot for tablespaces on YPCDBL > /tmp/20100704tablespaces.txt
//日志文件部分参数说明
BUFFERPOOLDFT_MON_BUFFERPOOL读写的次数，花费的时间
LOCKDFT_MON_LOCK锁等待次数，死锁
SORTDFT_MON_SORT使用的堆数量，排序性能
STATEMENTDFT_MON_STMT启动/停止时间，语句标识
TABLEDFT_MON_TABLE活动度量(读取/写入行)
UOWDFT_MON_UOW启动/终止次数，完成状态
TIMESTAMPDFT_MON_TIMESTAMP时间戳记