Re: Controlling adhoc queries

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