var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 Peformance issue on quad core server
I am using DB2 v9.1 Express edition on RHEL 5.
The problem I am facing is summarised as below:
While inserting data into a table on the following server configuration the task is completed in 15 seconds
Server 1 configuration:
Model NAme: Intel(R) Pentium(R) D CPU 3.00GHz
RAM: 2 GB
CORE DUO CPU
The same thing takes 1 minute to complete with a high end server having the same OS and DB2 version :
Model NAme: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz (HP brand)
RAM: 4 GB
QUAD CORE CPU
Are there any separate paramters that need to be tuned on the quad core processor boxes ?
Pls. help me in this issue so as to get the best performance.
Thanks in advance,
Is that the only difference between the two databases?
There are a lot of thing that can impact the performance. Like the number of indexes, number of rows already in the table, I/O bandwidth, tablespace type, and on and on.
First compare all the dbm and db config parameters and see what is different. you can also read this article and see if it can help: