?
Solved

How to do sizing for num_estore_segs and ESTORE_SEG_SZ to use extended memory

Posted on 2004-04-03
5
Medium Priority
?
696 Views
Last Modified: 2008-01-09
I am using DB2 7.2.3 Enterprise in Windows NT 4.0 Enterprise edition. How to do sizing for  num_estore_segs and ESTORE_SEG_SZ to use Extended menory ?

0
Comment
Question by:prabha_kar_d
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 18

Expert Comment

by:BigSchmuh
ID: 10796493
Choose the bufferpool which is the most used and allow only this one to use extended memory segments, then define those segments to have the same size and to consume your Available Physical Memory.

You can although use the /3GB boot.ini switch to allow your DB2 process to have 3Go addressable memory space instead of 2Go. I think the easiest way if your server have less than 4Gb RAM.

Hope this helps.
0
 

Author Comment

by:prabha_kar_d
ID: 10803121
Thanks for your reply Bigschmuh. I have configured few bufferpools to use extended memory. By setting  num_estore_segs and ESTORE_SEG_SZ parameters, is it use only physical memory ? How to configure to use virutal memory ?

0
 
LVL 18

Accepted Solution

by:
BigSchmuh earned 400 total points
ID: 10807602
You can not choose between virtual and real memory...
The DB2 process will use a maximum of 2Gb virtual memory (or 3Gb with the /3GB switch) which can be mapped to MORE real memory using the Windows AWE (starting with W2K Advanced server using /PAE switch) or DB2 extended memory segments (Less efficient because more pagination occurs but works on every platform).

Hope this helps.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month14 days, 2 hours left to enroll

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question