Re: Controlling adhoc queries

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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