Solved

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

Posted on 2004-04-03
5
662 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
  • 2
5 Comments
 
LVL 18

Expert Comment

by:BigSchmuh
Comment Utility
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
Comment Utility
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 100 total points
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
db2 - u 3 225
datediff of ssrs 3 184
I want coulmn name and value as output 18 55
Another SQL with parm Part 2 44 49
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 (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now