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

I think the posted statement was in error.  IIRC, when QRYTIMLMT (Query Time
Limit) is specified, if the estimator returns a value (in seconds) that
exceeds the defined time limit, then the query is not started.  There does
not appear to be any way to "force it to batch".

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



> -----Original Message-----
> From: Chris.Whisonant@comporium.com
> [mailto:Chris.Whisonant@comporium.com]
> Sent: Monday, September 09, 2002 8:34 AM
> To: midrange-l@midrange.com
> 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.
>
>