Re: Query Estimator (Was: Interactive Feature...)

I don't think this works, at least not exactly as desired. There's no
linkage between the optimizer message and time slice end pool settings. The
time slice end pool setting, found both as a system value QTSEPOOL and as
part of a job description, only movesa job to *BASE when it does not
complete by end of time slice--basically when an interactive job is found
to be long-running. It doesn't really change it to batch.

What's needed is something that can respond to the message that is sent
when the estimate exceeds the QRYTIMLMT value, to submit the query to batch.

You could always change that message not to have the 'I' response, and you
could add text that says you have to run this in batch.

At 02:46 PM 9/9/02 +0100, you wrote:

The term "time slice end" seems to be at the back of my mind and moving
these jobs to the machine pool  - or am I out in left field
somewhere?


----- Original Message -----
From: <Chris.Whisonant@comporium.com>
To: <midrange-l@midrange.com>
Sent: Monday, September 09, 2002 2:34 PM
Subject: Query Estimator (Was: Interactive Feature...)



Evan, you stated "This is any easy one to fix based on how long the
estimator thinks the query will run. You can force everything over x
minutes to batch rather than letting your users decide."

That sounds great, but for the life of me I cannot find where that setting
is located. Does anyone have more information on that?

Chris Whisonant
Comporium
IBM Certified Specialist
(803) 326-7270
mailto:chris.whisonant@comporium.com


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.