× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.