你的statement monitor switch打开了吗?没打开的话在同一个session里就不会有。(zxianing@b80eng) /home/zxianing$ db2 get monitor switches Monitor Recording SwitchesSwitch list for db partition number 0Buff...
显示全部你的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
收起