#-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時間戳記