我是rhel 跑db2 v10
情况如下
监视器已经打开
但是输入get snapshot
没有发现app is holding the oldest transaction这条
以下是在shell执行的情况
请问如何解决?
[db2inst1@rhel /database/db2inst1/NODE0000/SQL00002/LOGSTREAM0000]$ db2 get monitor switches
Monitor Recording Switches
Switch list for member 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = ON 2012-10-18 19:46:47.361412
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = ON 2012-10-18 19:45:59.889436
Table Activity Information (TABLE) = ON 2012-10-18 19:46:43.650042
Take Timestamp Information (TIMESTAMP) = ON 2012-10-14 05:20:47.463071
Unit of Work Information (UOW) = ON 2012-10-18 19:46:37.072898
[db2inst1@rhel /database/db2inst1/NODE0000/SQL00002/LOGSTREAM0000]$ db2 get snapshot for database on test|grep -i 'Appl id holding'
[db2inst1@rhel /database/db2inst1/NODE0000/SQL00002/LOGSTREAM0000]$
收起