DB2数据库执行慢
我的DB2数据库每天上午都非常卡,慢。查询一张表都要等N久。然后我 db2 "get snapshot for all bufferpools" 得到以下信息。不清楚该如何优化,救助各位大侠们多多赐教!非常感谢
Bufferpool Snapshot
Bufferpool name = IBMSYSTEMBP32K
Database name = QYDB
Database path = /home/db2inst1/db2inst1/NODE0000/SQL00001/MEMBER0000/
Input database alias =
Snapshot timestamp = 06/26/2015 09:38:13.557438
Buffer pool data logical reads = Not Collected
Buffer pool data physical reads = Not Collected
Buffer pool temporary data logical reads = Not Collected
Buffer pool temporary data physical reads = Not Collected
Buffer pool data writes = Not Collected
Buffer pool index logical reads = Not Collected
Buffer pool index physical reads = Not Collected
Buffer pool temporary index logical reads = Not Collected
Buffer pool temporary index physical reads = Not Collected
Buffer pool xda logical reads = Not Collected
Buffer pool xda physical reads = Not Collected
Buffer pool temporary xda logical reads = Not Collected
Buffer pool temporary xda physical reads = Not Collected
Buffer pool xda writes = Not Collected
Total buffer pool read time (milliseconds) = Not Collected
Total buffer pool write time (milliseconds)= Not Collected
Asynchronous pool data page reads = Not Collected
Asynchronous pool data page writes = Not Collected
Buffer pool index writes = Not Collected
Asynchronous pool index page reads = Not Collected
Asynchronous pool index page writes = Not Collected
Asynchronous pool xda page reads = Not Collected
Asynchronous pool xda page writes = Not Collected
Total elapsed asynchronous read time = Not Collected
Total elapsed asynchronous write time = Not Collected
Asynchronous data read requests = Not Collected
Asynchronous index read requests = Not Collected
Asynchronous xda read requests = Not Collected
No victim buffers available = Not Collected
Direct reads = Not Collected
Direct writes = Not Collected
Direct read requests = Not Collected
Direct write requests = Not Collected
Direct reads elapsed time (ms) = Not Collected
Direct write elapsed time (ms) = Not Collected
Database files closed = Not Collected
Unread prefetch pages = Not Collected
Vectored IOs = Not Collected
Pages from vectored IOs = Not Collected
Block IOs = Not Collected
Pages from block IOs = Not Collected
Node number = 0
Tablespaces using bufferpool = 0
Alter bufferpool information:
Pages left to remove = 0
Current size = 16
Post-alter size = 16