Bad disk perfomance with IBM DB2 - DMA present.
I have SUSE 8.2 running on P4 2,4 Ghz, I Gb RAM with 2 HDD 7200 RPM.
I'm installing SAP 4.6C server on IBM DB2 v.7.1 with fixpack.
Disk perfomance by hdparm -t is 50 Mb/sec for first drive and 20 Mb/sec for second drive. When SAP installer loading data in DB2 I have free swap, 5% CPU usage and HDD traffic no more 1 Mb/sec (by gkrellm) , and applications, that working with HDD works slow too. DB size if 17 Gb and full load need nearly 30 hours. DB data and tranasction loga are on different HDD. It seems me, that there are some boutleneck, maybe with number of avaliable buffers, but I dont lnow how to check it.
Last edited by Bogdan; 10-02-2003 at 08:51 AM.