Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 727
  • Last Modified:

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

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
prabha_kar_d
Asked:
prabha_kar_d
  • 2
1 Solution
 
BigSchmuhCommented:
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
 
prabha_kar_dAuthor Commented:
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
 
BigSchmuhCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now