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?
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
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.