sql监控

This the default setting.  To make sure the monitor switch off run the following to check:

db2 get dbm monitor switches

$ db2 get dbm monitor switches

      DBM System Monitor Information Collected

Switch list for db partition number 0
Buffer Pool Activity Information  (BUFFERPOOL) = OFF
Lock Information                        (LOCK) = ON  02/07/2012 21:37:58.374279
Sorting Information                     (SORT) = OFF
SQL Statement Information          (STATEMENT) = OFF
Table Activity Information             (TABLE) = OFF
Take Timestamp Information         (TIMESTAMP) = ON  02/07/2012 04:37:33.194722
Unit of Work Information                 (UOW) = OFF