银行数据库
谁能说下db2 get dbm monitor switches的作用
我以前只知道dbm cfg里的DFT_MON_****和get monitor switches
最近发现还有get dbm monitor switches这个参数，但是这个参数貌似可以通过update monitor switches来修改，但是修改后有时又和普通的monitor switches不太一样。它本身却没有update dbm monitor switches这样的命令
这个参数非常奇怪，也不是和dbm cfg里的DFT_MON_****参数有关联，不知道有什么作用
DB2的文档上称之为“实例级别监视开关”，是否指系统快照包括了实例级快照又包括了数据库级快照，可以分开设定是否收集？请指教
另外顺便问下，activate db 是否包括了restart db的功能，即激活数据库时，是否会进行数据库修复，还是要等到第一个connect过来时进行修复？这个问题的答案是否分版本不同？
最近发现还有get dbm monitor switches这个参数，但是这个参数貌似可以通过update monitor switches来修改，但是修改后有时又和普通的monitor switches不太一样。它本身却没有update dbm monitor switches这样的命令
这个参数非常奇怪，也不是和dbm cfg里的DFT_MON_****参数有关联，不知道有什么作用
DB2的文档上称之为“实例级别监视开关”，是否指系统快照包括了实例级快照又包括了数据库级快照，可以分开设定是否收集？请指教
另外顺便问下，activate db 是否包括了restart db的功能，即激活数据库时，是否会进行数据库修复，还是要等到第一个connect过来时进行修复？这个问题的答案是否分版本不同？
13同行回答
实例级的monitor switches是global的。 要仔仔细细“嚼“一下文档的意思。
http://publib.boulder.ibm.com/in ... c/core/r0001947.htm
GET MONITOR SWITCHES Command
Displays the status of the database system monitor switches for the current session. Monitor switches instruct the database system manager to collect database activity information. Each application using the database system monitor interface has its own set of monitor switches. This command displays them. To display the database manager-level switches, use the GET DBM MONITOR SWITCHES command.
Authorization
Required connection
Instance. If there is no instance attachment, a default instance attachment is created.
To display the settings for a remote instance, or for a different local instance, it is necessary to first attach to that instance.收起
http://publib.boulder.ibm.com/in ... c/core/r0001947.htm
GET MONITOR SWITCHES Command
Displays the status of the database system monitor switches for the current session. Monitor switches instruct the database system manager to collect database activity information. Each application using the database system monitor interface has its own set of monitor switches. This command displays them. To display the database manager-level switches, use the GET DBM MONITOR SWITCHES command.
Authorization
Required connection
Instance. If there is no instance attachment, a default instance attachment is created.
To display the settings for a remote instance, or for a different local instance, it is necessary to first attach to that instance.收起
浏览770
回复 5# drdb2
看看这个演示， 可以帮助理解：
$db2 get dbm cfg | grep DFT_MON_UOW
Unit of work (DFT_MON_UOW) = ON
$db2 get dbm monitor switches | grep UOW
Unit of Work Information (UOW) = ON 03/27/2011 17:01:32.369600
$db2 get monitor switches | grep UOW
Unit of Work Information (UOW) = ON 03/27/2011 17:01:32.369600
$db2 update monitor switches using UOW off
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
$db2 get monitor switches | grep UOW
Unit of Work Information (UOW) = OFF
$db2 get dbm monitor switches | grep UOW
Unit of Work Information (UOW) = ON 03/27/2011 17:01:32.369600收起
看看这个演示， 可以帮助理解：
$db2 get dbm cfg | grep DFT_MON_UOW
Unit of work (DFT_MON_UOW) = ON
$db2 get dbm monitor switches | grep UOW
Unit of Work Information (UOW) = ON 03/27/2011 17:01:32.369600
$db2 get monitor switches | grep UOW
Unit of Work Information (UOW) = ON 03/27/2011 17:01:32.369600
$db2 update monitor switches using UOW off
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
$db2 get monitor switches | grep UOW
Unit of Work Information (UOW) = OFF
$db2 get dbm monitor switches | grep UOW
Unit of Work Information (UOW) = ON 03/27/2011 17:01:32.369600收起
浏览803
仔细看看IBM文档， 就明白了。
“get monitor switches” -- Displays the status of monitor switches for the current session
“get dbm monitor switches” -- Displays the status of monitor switches for the database manager-level switches收起
“get monitor switches” -- Displays the status of monitor switches for the current session
“get dbm monitor switches” -- Displays the status of monitor switches for the database manager-level switches收起
浏览778
我模拟你的情况如下：
win2)db2 get dbm cfg | grep DFT_MON_SORT
Sort (DFT_MON_SORT) = ON
win2)db2 get dbm monitor switches | grep SORT
Sorting Information (SORT) = OFF
win2)db2 get monitor switches | grep SORT
Sorting Information (SORT) = OFF
win2)db2 terminate
DB20000I The TERMINATE command completed successfully.
win2)db2 get dbm monitor switches | grep SORT
Sorting Information (SORT) = OFF
win2)db2 get monitor switches | grep SORT
Sorting Information (SORT) = OFF
## 在另一个窗口， 重启实例
win2)db2 get dbm monitor switches | grep SORT
Sorting Information (SORT) = ON 03/29/2011 12:50:03.140040收起
win2)db2 get dbm cfg | grep DFT_MON_SORT
Sort (DFT_MON_SORT) = ON
win2)db2 get dbm monitor switches | grep SORT
Sorting Information (SORT) = OFF
win2)db2 get monitor switches | grep SORT
Sorting Information (SORT) = OFF
win2)db2 terminate
DB20000I The TERMINATE command completed successfully.
win2)db2 get dbm monitor switches | grep SORT
Sorting Information (SORT) = OFF
win2)db2 get monitor switches | grep SORT
Sorting Information (SORT) = OFF
## 在另一个窗口， 重启实例
win2)db2 get dbm monitor switches | grep SORT
Sorting Information (SORT) = ON 03/29/2011 12:50:03.140040收起
浏览340