关于DB2快照的问题
在CLP级别，会话级全部打开了monitor switches
[db2inst1@db2 ~]$ db2 "select DISTINCT 'xxx.',AGENT_ID from sysibmadm.APPLICATIONS with ur " | grep -i xxx |awk '{print $2}'
52
54
55
56
57
58
59
73
65587
[db2inst1@db2 ~]$ db2 get snapshot for application applid 57
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 52
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 55
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 56
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 58
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 59
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 73
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 65587
SQL1611W No data was returned by Database System Monitor.
为啥全部都没采集到信息呢？？
[db2inst1@db2 ~]$ db2 get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 09/28/2010 18:39:37.837196
Lock Information (LOCK) = ON 09/28/2010 18:39:37.837196
Sorting Information (SORT) = ON 09/28/2010 18:39:37.837196
SQL Statement Information (STATEMENT) = ON 09/28/2010 18:39:37.837196
Table Activity Information (TABLE) = ON 09/28/2010 18:39:37.837196
Take Timestamp Information (TIMESTAMP) = ON 09/28/2010 18:39:37.837196
Unit of Work Information (UOW) = ON 09/28/2010 18:39:37.837196
[db2inst1@db2 ~]$ date
Tue Sep 28 18:52:17 CST 2010
我都打开了10多分钟了。我想问下这个快照要咋才能收集信息呢？我是在会话级全部打开的
db2 update monitor switches using BUFFERPOOL ON LOCK ON SORT ON STATEMENT ON TABLE ON TIMESTAMP ON UOW ON
[db2inst1@db2 ~]$ db2 "select DISTINCT 'xxx.',AGENT_ID from sysibmadm.APPLICATIONS with ur " | grep -i xxx |awk '{print $2}'
52
54
55
56
57
58
59
73
65587
[db2inst1@db2 ~]$ db2 get snapshot for application applid 57
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 52
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 55
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 56
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 58
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 59
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 73
SQL1611W No data was returned by Database System Monitor.
[db2inst1@db2 ~]$ db2 get snapshot for application applid 65587
SQL1611W No data was returned by Database System Monitor.
为啥全部都没采集到信息呢？？
[db2inst1@db2 ~]$ db2 get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 09/28/2010 18:39:37.837196
Lock Information (LOCK) = ON 09/28/2010 18:39:37.837196
Sorting Information (SORT) = ON 09/28/2010 18:39:37.837196
SQL Statement Information (STATEMENT) = ON 09/28/2010 18:39:37.837196
Table Activity Information (TABLE) = ON 09/28/2010 18:39:37.837196
Take Timestamp Information (TIMESTAMP) = ON 09/28/2010 18:39:37.837196
Unit of Work Information (UOW) = ON 09/28/2010 18:39:37.837196
[db2inst1@db2 ~]$ date
Tue Sep 28 18:52:17 CST 2010
我都打开了10多分钟了。我想问下这个快照要咋才能收集信息呢？我是在会话级全部打开的
db2 update monitor switches using BUFFERPOOL ON LOCK ON SORT ON STATEMENT ON TABLE ON TIMESTAMP ON UOW ON