I am running DB2 v8.1.6a on win2k platform...

The issue that we are confronted with is that the same set of queries (part of two different product releases eg: R1.0 and R1.1) run against same database with all db/dbm and other related settings remaining constant yielding us different timing. While we expect the timing to be same if not better.. difference in timing is really worrying and customer wants to know the reason why this is happening...

Some thing that i have checked..

* DB settings
* Explain plan statements
* SQL statements + optimization
* Data sets
* Hardware, load on the system, no. of users etc

Any ideas greatly appreciated.

Thanks.

did you see same access paths for both sets of queries in the explain plan? there is a chance query getting modified with new release

yes i did - but no difference there, i mean access plan looks good.

Try running an event monitor trace and compare the results.

James Campbell

i.e. type "db2set -g"

In the explain plan, check if the estimated cost is the same

need more info on this..can you post both accessplans here?

thanks for your response... I am reading explain plan output and trying to compare it with both versions... shall keep you posted on how it goes.

thanks once again.