Re: Time out in Run SQL Scripts

Hi Jon,

This might help if the QUERY_TIME_LIMIT setting in QAQQINI is not *NOMAX.
These statements can be run from Run SQL Scripts...

--Establish QAQQINI override (QTEMP.QAQQINI is created based upon the
current QAQQINI being used in the job)
call QSYS2.OVERRIDE_QAQQINI( 1, '', '' )
;
--Optimize for *NOMAX query time limit
call QSYS2.OVERRIDE_QAQQINI( 2, 'QUERY_TIME_LIMIT', '*NOMAX' );

--Run queries here...

--When all done, if desired, you can discard override values and resume
using the previous QAQQINI file settings:
call QSYS2.OVERRIDE_QAQQINI( 3, '', '' )
;

If that doesn't help, and your system value QQRYTIMLMT is not set to
*NOMAX, you may need to set it to *NOMAX.

If you're running a long running UDF function, you may need to override the
QAQQINI UDF_TIME_OUT setting.

Mike

date: Tue, 31 May 2016 12:11:50 -0400
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Time out in Run SQL Scripts

Anyone know how to change the time-out value in ACS Run SQL Scripts? I
have some complex SQL that I need to test and it is timing out on me before
I see any results.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com