hello,刚开始学db2不久,在监控数据这章,遇到一个问题,是关于实例级别的监控开关的问题,现象如下:
db2inst1@singl:~> 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 2013-03-29 12:47:48.075982
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 2013-03-29 07:53:13.858113
Unit of Work Information (UOW) = OFF
db2inst1@singl:~> db2 termnate
db2inst1@singl:~> db2 attach to db2inst1
Instance Attachment Information
Instance server = DB2/LINUXX8664 9.7.0
Authorization ID = DB2INST1
Local instance alias = DB2INST1
--关闭实例级别开关db2inst1@singl:~> db2 update dbm cfg using dft_mon_lock offDB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
db2inst1@singl:~> db2 detach
DB20000I The DETACH command completed successfully.
db2inst1@singl:~> db2 list active databases
SQL1611W No data was returned by Database System Monitor.
--查看实例级别开关关闭db2inst1@singl:~> 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) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 2013-03-29 07:53:13.858113
Unit of Work Information (UOW) = OFF
db2inst1@singl:~> db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE--连接数据库之后,实例级别开关打开了又?
db2inst1@singl:~> 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 2013-03-29 12:49:41.761830
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 2013-03-29 07:53:13.858113
Unit of Work Information (UOW) = OFF
为什么实例开关会自动打开?
非常不解,望各位老手解答,谢谢
收起