Re: Time Limit on Queries

[DennisLovelady@xxxxxxxxx (Dennis Lovelady)]

Hi, Leo:

If you submit your job with INQMSGRPY(*RQD) specified, this
should not occur.  You can change the problem Job Description,
or change the SBMJOB command that is used to submit the query
(assuming it's done by a user or by some user-written program)...
_OR_ you can add an entry to your system reply list (WRKRPYLE),
specifying that a response is *RQD for this message ID.

If it's a query that's submitted by selecting "Run query in
batch" from the WRKQRY menu (or whatever), then your only
options are to alter the JOBD or to use WRKRPYLE.

I hope this helps.

  (The following signature looks right only with a fixed-pitch font)
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
*      _                                                      _       *
*     / )                                                    ( \      *
*  _ / /                  Dennis Lovelady                     \ \ _   *
* ( ( ()    _      Unix / AIX System Administrator       _    () ) )  *
*( \ \ \)  / )             Oracle D.B.A.                ( \  (/ / / ) *
( \ \ \ \_/ /   http://cybercity.piedmont.net/~dennis    \ \_/ / / / )*
*\         /            Dennis@Lovelady.com               \         / *
* \       /          Dennis.Lovelady@KEMET.com             \       /  *
/~~\     /~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\     /~/\* 
   [[[|]]]               Simpsonville, SC.                  [[[|]]](  *
\__[[[|]]]__________________________________________________[[[|]]]_\/



Leo Lefebvre <leo@tug.on.ca> on 11/25/97 12:50:10 PM
To: MIDRANGE-L <MIDRANGE-L@midrange.com> @ INTERNET
cc:  
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

+---
| 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
+---