Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    1

    Unanswered: Perforamnce issues after Deployment

    Hey there,

    it feels like I search the entire forum but still couldn't find the trick working for me.
    My problem is as follows:

    I have a db2 v9.7 64bit fix pack 6 instance running on my local machine (win, intel i5 2,5ghz, 8gb ram). Everything was fine back then but when I moved to a windows 2008 64bit server (2 x intel xenon e312 2,00ghz, 32 ram, db2 v10.5 fix pack 3 ese) the performance got worse. The workload and queryies are exactly the same even the accessplan and the overall configuration are with a few exceptions equal.

    I have some really big join statements. While executing them the server reaches 100% cpu usage and takes its time aprox. 15min whereas my local machine is much faster.
    I have noticed that the cpuspeed on the server mesuared by db2 is 5 times slower than on my local machine.

    Is this due to hardware issues or can this be fixed with some db2 tuning, if so how?


    optimízer

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    run explain and check the plan
    do you have an explain from previous run.. compare access path
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    If the 2 e312 processors each have 4 cores, and all 8 cores available to db2, then in addition to verifying your claim that the access plans for the joins are identical, compare also the dbm cfg and db cfg and db2 registry settings between the two environments, and the bufferpool(s) configurations.

Tags for this Thread

Posting Permissions

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