The MEMLIMIT parm is discussed in PK03680. ...In the absence of an explicit MEMLIMIT setting, DB2 uses 4 TB. If MEMLIMIT is specified, DB2 only honors MEMLIMIT settings above 4 TB...In summary, MEMLIMIT is an upper limit, it does not imply usage. DB2 does allocate memory objects above the 2GB bar - but only uses what it needs. It remains important to monitor use of real and auxiliary storage, and to avoid allocating buffer pools to be larger than real storage...
Cheers 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? Anyone have a standard calculation they use to set these values? -------------------------------------------------------- This email and associated attachments may contain confidential and privileged CITEC information that is provided solely for the use of the intended addressee. Views and opinions expressed in this email are those of the individual sender and are not necessarily the views and opinions of CITEC unless the sender expressly states that such views and opinions are those of CITEC. The privilege and confidentiality associated with this email and attachments will not be waived, lost or rescinded by reason of mistaken delivery. Should you receive this email by mistake, please notify the sender by return email then delete the email from your computer system. You must not use, copy, modify, print, or distribute the email or the information and attachments contained within same to any third party. CITEC does not accept any liability in respect of viruses or computer problems experienced by the recipient through access gained to this email and its attachments. -------------------------------------------------------- ________________________________________________________________________ This email has been scanned for viruses by the CITEC Email Anti-Virus service powered by MessageLabs. For more information on a proactive email anti-virus service working around the clock, around the globe, visit www.citec.com.au ________________________________________________________________________ ---------------------------------------------------------------------- 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