Re: Controlling adhoc queries

You were absolutely correct!!!

Thanks for that.

As for un-installing there is only one option so I am guessing that will
remove ALL rather than being able to select ?

Cheers

Don Brown





From: "Charles Wilt" <charles.wilt@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 15/03/2018 01:53 AM
Subject: Re: Controlling adhoc queries
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



You've got more than one version installed and you're not running the
version you think you are...

- Installed using install_acs_XX_allusers.js
- and using install_acs_XX.js

Been there done that!

I ran both for the latest version ...I suppose you could fiqgure out which
one you don't want and delete it...

Charles



On Tue, Mar 13, 2018 at 11:16 PM, Don Brown <DBrown@xxxxxxxxxx> wrote:

Hi Tim,

I have the latest version if iACS but I do not have the Schema option
under Database - can you advise ?

Thanks



Don Brown





From: "Timothy P Clark" <timclark@xxxxxxxxxx>
To: "Midrange Systems Technical Discussion"

<midrange-l@xxxxxxxxxxxx>

Date: 14/03/2018 01:51 AM
Subject: Re: Controlling adhoc queries
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Don,

Your timing is so perfect, I'd think someone were paying you... :-)

I'm at this moment working on an article describing some enhancements

that

IBM is making to the MAXTMPSTG parameter available on the
CRTCLS/CHGCLS/CHGJOB commands. These enhancements are intended to help
control runaway ad-hoc queries that use excessive temporary storage,
particularly when *SYSBAS is running low on space. You may also want to
look at the CPUTIME parameter which limits the amount of actual

processing

time a job may use.

The article about MAXTMPSTG should go live on DeveloperWorks in the next
few weeks. It will be part 3 of the series that starts here:
https://ibm.co/2tIv9QR. The 7.3. PTFs that provide the enhancement are
available right now: MF64447, MF64448, MF64449, MF64450, SI66499, and
SI66500. You'll want to read the cover letters to understand some of the
nuances of the enhancements.

Hope that helps...

Tim Clark
Db2 for IBM i


--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud

service.

For more information please visit http://www.symanteccloud.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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD