By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

Reliable timeron and Query Patroller

P: n/a

We are looking to install Query Patroller but after a while, we
discover that a certain
% of our query don't have a reliable timeron. We have queries where
the timeron is huge (trillions) but the response time is fast (less
than 3 minutes) and other queries where the timeron is small but the
response time is long (more than an hour).

We do make runstats religiously on our database but still have the
portion of the query with the wrong timeron (approximately 5% of all

My question is : How can we implement queue in Query Patroller to split
heavy query and fast query since the only driver to assign query to
queue is the timeron? Do we miss something?

We called IBM and they told us that since we have queries using "With"
statement, DB2 generate temporary table and those temporary table don't
have statistic and that`s why we do have wrong timeron.

Any idea or clue on how to implement queuing in Query Patroller without
pushing the heavy query in the small queue (50000 timerons or less) and
vice versa for the fast query in big queue?

Jean-Guy Roy

Aug 18 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.