Long Query Times

[rstockton]

We seem to experience a situation where we ocassionally get long query times when a user or multiple users enter the same query at near the same time,  Has anyone had this problem and if so how did you overcome it.

Thanks

[demaya]

What OD and DB2 Version?

[rstockton]

OD 8.4.1.2
DB2 9.5.4

[demaya]

Mhhm I think the OD isn't the problem. Since there is a DB2 V10 out, you should think about upgrading?

There are thousands of fixes and some are especially for the performance...

If you want to tune your 9.5 you should have a look at 'db2 autoconfigure apply none'. It will turn out if you have something misconfigured. Pay attention before changing something (test it!). Are the stats up to date?

Cheers