Text only | Text with Images

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: rstockton on November 09, 2012, 10:04:02 PM

Title: Long Query Times
Post by: rstockton on November 09, 2012, 10:04:02 PM
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
Title: Re: Long Query Times
Post by: demaya on November 12, 2012, 12:29:31 PM
What OD and DB2 Version?
Title: Re: Long Query Times
Post by: rstockton on November 13, 2012, 10:26:43 PM
OD 8.4.1.2
DB2 9.5.4
Title: Re: Long Query Times
Post by: demaya on November 14, 2012, 07:36:44 AM
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
Text only | Text with Images