Re: Controlling adhoc queries

[Don Brown <DBrown@xxxxxxxxxx>]

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