« previous next »
Pages: [1]

Author Topic: Long Query Times  (Read 2422 times)

rstockton

  • Guest
Long Query Times
« on: November 09, 2012, 03: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
Logged

demaya

  • Guest
Re: Long Query Times
« Reply #1 on: November 12, 2012, 05:29:31 AM »
What OD and DB2 Version?
Logged

rstockton

  • Guest
Re: Long Query Times
« Reply #2 on: November 13, 2012, 03:26:43 PM »
OD 8.4.1.2
DB2 9.5.4
Logged

demaya

  • Guest
Re: Long Query Times
« Reply #3 on: November 14, 2012, 12: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
Logged
Pages: [1]
« previous next »