|
Where can I find info contrasting "how they are scoped and\or activated"?override support". They are all the /same/ for effect, that either *NOMAX
Thanks
-----Original Message-----
From: CRPence [mailto:crpbottle@xxxxxxxxx]
Sent: Wednesday, July 06, 2016 7:09 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: QQRYTIMLMT vs QAQQINI
On 06-Jul-2016 16:48 -0500, Justin Taylor wrote:
We've had a number of run-away queries, and I'd like to set someThe system-wide default is determined by the system-value
limits. It looks to me like both QQRYTIMLMT
(http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzakz/rzakzq
q
rytimlmt.htm)
and QAQQINI
(https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzajq/qryop
t
.htm) would work. I'm just curious if anyone knows of any practical
difference between the two options.
QQRYTIMLMT unless a request to Change Query Attributes (CHGQRYA) has
specified a Query Processing Time Limit (QRYTIMLMT) other than the
value of *SYSVAL [which requests, the default, to redirect to the
system-value], or the QAQQINI options file has established a value for
QUERY_TIME_LIMIT per specification of a Query Options File Library
(QRYOPTLIB) in which a valid QAQQINI file resides with that QQPARM
with a QQVAL other than '*SYSVAL', or the latter having been effected
instead with the
QSYS2.override_qaqqini() SQL Stored Procedure for the "QAQQINI file
--
Regards, Chuck
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.