互联网服务数据库
关于db2pd底层原理
我先连接上数据库，后执行了个查询语句，在执行db2pd -d sample -dyn就能显示刚才执行的sql；接着我connect reset断开连接，在连接上数据库，在执行db2pd -d sample -dyn，就没有结果显示，db2pd直接从内存获取数据，难道是断开连接后，内存被释放了？？？...显示全部
查看其它 2 个回答tongjixianing的回答
你的statement monitor switch打开了吗？没打开的话在同一个session里就不会有。
(zxianing@b80eng) /home/zxianing
$ db2 get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 02/21/2012 02:25:50.987024
Lock Information (LOCK) = ON 02/21/2012 02:25:50.987024
Sorting Information (SORT) = ON 02/21/2012 02:25:50.987024
SQL Statement Information (STATEMENT) = ON 02/21/2012 02:25:50.987024
Table Activity Information (TABLE) = ON 02/21/2012 02:25:50.987024
Take Timestamp Information (TIMESTAMP) = ON 02/21/2012 02:20:08.707438
Unit of Work Information (UOW) = ON 02/21/2012 02:25:50.987024
(zxianing@b80eng) /home/zxianing
$ db2 "select * from t1"
C1
-----------
0 record(s) selected.
(zxianing@b80eng) /home/zxianing
$ db2 connect reset
DB20000I The SQL command completed successfully.
$ db2 connect to db97
Database Connection Information
Database server = DB2/AIX64 9.7.4
SQL authorization ID = ZXIANING
Local database alias = DB97
(zxianing@b80eng) /home/zxianing
$ db2pd -db db97 -dyn
0x0700000043B903E0 611 1 1 1 3 3 select * from t1
(zxianing@b80eng) /home/zxianing
$ db2 get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 02/21/2012 02:25:50.987024
Lock Information (LOCK) = ON 02/21/2012 02:25:50.987024
Sorting Information (SORT) = ON 02/21/2012 02:25:50.987024
SQL Statement Information (STATEMENT) = ON 02/21/2012 02:25:50.987024
Table Activity Information (TABLE) = ON 02/21/2012 02:25:50.987024
Take Timestamp Information (TIMESTAMP) = ON 02/21/2012 02:20:08.707438
Unit of Work Information (UOW) = ON 02/21/2012 02:25:50.987024
(zxianing@b80eng) /home/zxianing
$ db2 "select * from t1"
C1
-----------
0 record(s) selected.
(zxianing@b80eng) /home/zxianing
$ db2 connect reset
DB20000I The SQL command completed successfully.
$ db2 connect to db97
Database Connection Information
Database server = DB2/AIX64 9.7.4
SQL authorization ID = ZXIANING
Local database alias = DB97
(zxianing@b80eng) /home/zxianing
$ db2pd -db db97 -dyn
0x0700000043B903E0 611 1 1 1 3 3 select * from t1
浏览487