Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered: DB2 Peformance issue on quad core server

    Hi,

    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,

    Abhay

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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:

    http://www.ibm.com/developerworks/db...m-0403wilkins/

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •