MAXTEMPS in DB2 9 for z/OS

Mark Labby

MAXTEMPS in DB2 9 for z/OS

We are about to go to DB2 9 CM on z/OS this weekend in production.  One of the new settings we are having some internal discussions on is the MAXTEMPS setting to control the maximum amount of temporary workspace a single job can use.  The default setting is 0, which works the same as in DB2 before - no limit on any job.

How have you used this in your shops?  Have you let the default or been trying to pick a memory setting that stops one job from taking all the space and pushing other jobs out?

Any comments about your experience with this will be appreciated. ===== This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging in the unauthorized use of this message. =====

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

Cuneyt Goksu

Re: MAXTEMPS in DB2 9 for z/OS
(in response to Mark Labby)
Mark,

We did not let the default.
As a rule of thumb start with 1/3 of your total Workfile. Do this
calculation after you increase 32K Workfiles (Bufferpool and Dataset)

Monitor the following if an agent hits MAXTEMPS.

SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE
RESOURCE.
REASON 00C90305, TYPE OF RESOURCE 100, AND RESOURCE NAME = 'WORKFILE
DATABASE'
SQLSTATE = 57011

And Check your Statistics Report columns AGENT MAX STORAGE (KB) and NUMBER
OF MAX EXCEEDED 0

Regards, Cuneyt


-----Original Message-----
*From:* IDUG DB2-L [mailto:[login to unmask email] *On Behalf Of *Mark Labby
*Sent:* Monday, February 14, 2011 5:48 PM
*To:* [login to unmask email]
*Subject:* [DB2-L] MAXTEMPS in DB2 9 for z/OS


We are about to go to DB2 9 CM on z/OS this weekend in production. One of
the new settings we are having some internal discussions on is the MAXTEMPS
setting to control the maximum amount of temporary workspace a single job
can use. The default setting is 0, which works the same as in DB2 before -
no limit on any job.

How have you used this in your shops? Have you let the default or been
trying to pick a memory setting that stops one job from taking all the space
and pushing other jobs out?

Any comments about your experience with this will be
appreciated.======
This message contains privileged and confidential information intended for
the above addressees only. If you receive this message in error please
delete or destroy this message and/or attachments. The sender of this
message will fully cooperate in the civil and criminal prosecution of any
individual engaging in the unauthorized use of this message.
=====

------------------------------

[image: Independent, not-for-profit, User Run - the IDUG
difference! ] < http://www.idug.org/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Phil Grainger

Re: MAXTEMPS in DB2 9 for z/OS
(in response to Cuneyt Goksu)
Hi Mark

I assume you know about the 4K vs 32K work file changes in DB2 9?

Basically, unless you have ZERO 32K work space in DB2, when you go to DB2 9 (even CM) you should have AT LEAST AS MUCH 32K work file space as you had 4K in DB2 V8

This is because DB2 9 favours 32K page sorting wherever possible - DB2 V8 uses 4K pages unless it HAS to use 32K

I've seen far too many people bitten by this - and (of course) it only REALLY hurts in production!

Phil G

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Mark Labby
Sent: 14 February 2011 15:48
To: [login to unmask email]
Subject: [DB2-L] MAXTEMPS in DB2 9 for z/OS


We are about to go to DB2 9 CM on z/OS this weekend in production. One of the new settings we are having some internal discussions on is the MAXTEMPS setting to control the maximum amount of temporary workspace a single job can use. The default setting is 0, which works the same as in DB2 before - no limit on any job.

How have you used this in your shops? Have you let the default or been trying to pick a memory setting that stops one job from taking all the space and pushing other jobs out?

Any comments about your experience with this will be appreciated. ====== This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging in the unauthorized use of this message. ======
________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv