Re: Time Limit on Queries

[Doug Hart <dhart@xxxxxxxx>]

   You should look at your 'system reply list' to see if CPA4259
   is being managed by it.

   Also, I have found the estimates query makes for expected run time 
   to be way off.  I have been forced to set my limits to 60 minutes
   (3600 sec) to handle high estimates when the query task will only
   take a few minutes to process.  

   I had a problem on a 30S server which we allow remote SQL access
   to by a product named QUEST.  The query would build a huge QTEMP
   work file and max out my DASD crashing my system.  I set my
querylimit
   value low to help control this but blocked many QUEST runs.  I ended
   up setting the max storage on the user profiles to control my 
   problem.

On 25-Nov-97, Leo Lefebvre wrote:
>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!


>TIA

>-- 
>Leo Lefebvre
>leo@tug.on.ca
>Toronto Users Group for Midrange Systems
>Ph: (416) 606-5960   ---   Fx: (416) 495-0100
>                           

-- 
Doug Hart -  dhart@mail.com         President
Sr. Consulting Technical Analyst    Central New York AS/400 User Group
IBM AS/400 Technologies             Visit us:  http://www.cny400ug.org


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