Re: Controlling adhoc queries

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Very cool, Tim - thanks for this!

Vern

On 4/12/2018 8:38 AM, Timothy P Clark wrote:
> I apologize for resurrecting an old thread, but that's how long it's taken
> for my article to wend its way through the hallowed halls of IBM.
> Nevertheless, I'm happy to announce that it is now publically viewable at
> https://ibm.co/2GSx77c. Hopefully it can be of some help to anyone who is
> struggling to bring adhoc queries under control.
>
> Tim Clark
> Db2 for IBM i
>
> > From: "Timothy P Clark" <timclark@xxxxxxxxxx>
> > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
> > Date: 03/13/2018 10:50 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