DB2性能监控和调优Bufferpool篇
1，打开监视器记录开关
>db2 update monitor switches using BUFFERPOOL ON 数据库
2,查看BUFFERPOOL相关指标
db2 => get snapshot for bufferpools on sade数据库
Bufferpool Snapshot
Bufferpool name = IBMDEFAULTBP
Databa name = 数据库
Databa path = /home/数据库/db2inst1/NODE0000/SQL0
0001/
Input databa alias = 数据库
anyway you want itSnapshot timestamp = 2012-08-29 14:26:56.680488
mofileBuffer pool data logical reads = 9352343767
Buffer pool data physical reads = 7842064458
Buffer pool temporary data logical reads = 1394631
Buffer pool temporary data physical reads = 1003790
Buffer pool data writes = 14196736
Buffer pool index logical reads = 984092635
Buffer pool index physical reads = 18007186
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Total buffer pool read time (ms) = 189662232
Total buffer pool write time (ms) = 67254105
Asynchronous pool data page reads = 7655365979
Asynchronous pool data page writes = 12202419
Buffer pool index writes = 6803875
Asynchronous pool index page reads = 573236
Asynchronous pool index page writes = 5770911
Total elapd asynchronous read time = 171898253
Total elapd asynchronous write time = 52416888
Asynchronous data read requests = 487634359
Asynchronous index read requests = 364145
No victim buffers available = 185403798
Direct reads = 10028
smartmediaDirect writes = 0
Direct read requests = 2858
Direct write requests = 0
Direct reads elapd time (ms) = 13793
Direct write elapd time (ms) = 0
Databa files clod = 0
Data pages copied to extended storage = 0
Index pages copied to extended storage = 0
Data pages copied from extended storage = 0
Index pages copied from extended storage = 0
伦敦气温Unread prefetch pages = 1144034
Vectored IOs = 484334896
Pages from vectored IOs = 7641815885
Block IOs = 0
Pages from block IOs = 0
Physical page maps = 0
Node number = 0
Tablespaces using bufferpool = 6
Alter bufferpool information:
Pages left to remove = 0
Current size = 1000june是什么意思
小区设计说明
Post-alter size = 1000
斑秃原因
Bufferpool Snapshot
Bufferpool name = BUF32K
Databa name = 数据库
坏女孩ellaDataba path = /home/数据库/db2inst1/NODE0000/SQL0
0001/
Input databa alias = 数据库
Snapshot timestamp = 2012-08-29 14:26:56.680488
Buffer pool data logical reads = 9226695
Buffer pool data physical reads = 2008888
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Buffer pool data writes = 101384
Buffer pool index logical reads = 62590234
初中Buffer pool index physical reads = 4053773
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Total buffer pool read time (ms) = 37248151
Total buffer pool write time (ms) = 46552581
Asynchronous pool data page reads = 1944310
Asynchronous pool data page writes = 94789
Buffer pool index writes = 3337380
Asynchronous pool index page reads = 3363
Asynchronous pool index page writes = 3115461
Total elapd asynchronous read time = 5191750
Total elapd asynchronous write time = 38441497
Asynchronous data read requests = 122069
Asynchronous index read requests = 2885
No victim buffers available = 4171187
Direct reads = 0
