Everyone knows that the LRUs are crucial to good performance, the following shows the performance difference at the extremes.
Load Trans Run TPS Avg Trans Time Time 1 5 11576 300 38.587 0.025916 1 10 11581 301 38.475 0.025991 1 20 11587 301 38.495 0.025977 1 30 11609 309 37.570 0.026617 BUFFERPOOL size=2K,buffers=1200000,lrus=128,lru_min_dirty=0.100000,lru_max_dirty=0.200000 1 5 581482 300 1938.273 0.000516 1 10 792848 300 2642.827 0.000378 1 20 917432 300 3058.107 0.000327 1 30 1235902 300 4119.673 0.000243 BUFFERPOOL size=2K,buffers=1200000,lrus=128,lru_min_dirty=80.000000,lru_max_dirty=95.000000
Then it was noticed the OS was detecting disk warning so the dbspaces were moved to another disk.
1 5 790026 300 2633.420 0.000380 1 10 1341482 300 4471.606 0.000224 1 20 1644233 300 5480.777 0.000182 1 30 1621288 300 5404.293 0.000185 BUFFERPOOL size=2K,buffers=1200000,lrus=128,lru_min_dirty=80.000000,lru_max_dirty=95.000000
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.