Re: Time Limit on Queries

Instead of changing the system value.  Try using the CHGQRYA command in a
user signon program.  This way all interactive users will get the warning
but batch jobs should run without incident.  This includes batch jobs
submitted by a user.

Rob Ward
M-C Industries, Inc.

-----Original Message-----
From: Leo Lefebvre <leo@tug.on.ca>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Tuesday, November 25, 1997 11:43 AM
Subject: Time Limit on Queries


>Hi,
>
>I changed the System Value QQRYTIMLMT to 300 (seconds) to limit the
>query runs to about 5 minutes.
>
>In the interactive environment, the user gets the message CPA4259 when
>the query is about take longer than the time limit, with the option to
>continue or cancel the request. That works fine.
>
>But when the request is executed in batch mode, the message gets
>AUTOMATICALY the default reply 'C', not allowing anyone to enter a
>reply. The only messages sent are 1) the user receives a message saying
>that the system operator received a message, and 2) the system operator
>receives a message saying the 'previous cl command failed' with options
>C, D, I, and R. The reply to this message, obviously, will not allow the
>job to run regardless of the time limit, but will either cancel/ignore
>the query request (options C, D or I) or retry the same query request
>(option R) with the same parameters, just to get the same results.
>Unless, before replying with an 'R', somebody change the system value to
>a greater number.
>
>What would be the best way to operate, when the job is a 'batch' type,
>to allow someone (the user or the system operator) to use his/her
>judgement to kill the request or to continue.
>We do have many programs with OPNQRYF and I would appreciate if I would
>not have to modify all of them!
>


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---