On Wed, 23 Aug 2006 14:16:16 -0500, Tom Moulder
<[EMAIL PROTECTED]> wrote:
>I'd like to know what shops are doing for DB2 V8 and storage above the bar.
>Anyone care to share what they have as settings for MEMLIM on the DBM1 start
>up proc and MLMT on the IRLM startup proc?
>
1) DB2 V8 doesn't care what you code in the proc or IEFUSI for MEMLIMIT
for the DBM1 address space and IRLM. DBM1 gets 4T (unless it can get
MEMLIMIT=NOLIMIT via REGION=0) and IRLM gets at least 2G but you can
code something higher for IRLM.
I have MEMLIMIT(10G)in SMFPRMxx as my default.
Here are my MEMLIMIT / IEFUSI "rules":
JCL DEFINITION MEMLIMIT
------------------------------------------------------------
NO MEMLIMIT DEFINITION TAKEN FROM SMFPRMXX MEMLIMIT
REGION=0M (JOB) + NO MEMLIMIT 5GB
REGION=0M (STC) + NO MEMLIMIT NOLIMIT (16383PB)
MEMLIMIT= <5GB AS REQUESTED
MEMLIMIT= >=5GB 5GB
In otherwords, I am trying to discourage people coding
MEMLIMIT at all. Don't worry about it... I'll take care of
it just like I have done for REGION size.
Only STCs can have MEMLIMIT=NOLIMIT via REGION=0M specification
(REGION=0M is also protected from all but STCs in my IEFUSI).
>
>Anyone have a standard calculation they use to set these values?
>
The DB2 manuals should help you there (based on buffer pool
sizes). Before I set my default in SMFPRMxx and coded up
IEFUSI changes for MEMLIMIT, I made sure that 10G was enough
for DB2. The DB2 folks did the calculations based on information in
the DB2 manuals and our specific configuration(s). Of course
that was before I knew that DBM1 didn't give a hoot what I
coded and would get at least 4T.
HTH,
Mark
--
Mark Zelden
Sr. Software and Systems Architect - z/OS Team Lead
Zurich North America / Farmers Insurance Group
mailto: [EMAIL PROTECTED]
z/OS and OS390 expert at http://searchDataCenter.com/ateExperts/
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
