Re: Time out in Run SQL Scripts

Well it turned out that it wasn’t a time out - just reported that way!

A colleague had seen it before and recognized this as the symptoms of an RPG UDF program failure. Checked the log and sure enough that was the problem.

Thanks to all for the assistance.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 31, 2016, at 1:24 PM, Mike Jones <mike.jones.sysdev@xxxxxxxxx> wrote:

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.