Reliable timeron and Query Patroller

[JohnnyDeep]

Hi,

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
query)

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