Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing buffer pool size

Status
Not open for further replies.
Powernic

Powernic

Programmer
Dec 7, 2004
6
0
0
BE

Hello

I am trying to increase the buffer pool size of a new installation of DB2 Universal Database 7.

I specified 250,000 4k pages to be used (our server has 2 gig ram). However the process memory reported by windows never goes higher than 400mb. I disconnected all clients, even restarted the service, I can't seem to be using more than 400mb.

When explaining a select, in the optimization parameters, I can see that BUFFPAGE has a current value of 250,000, but an explained value of 95,000. Again this seems to indicate that the new setting was not taken into account.

Any help on this subject?

Thank you very much

Nicolas.


 
Status
Not open for further replies.

Similar threads

Milind Taralkar
  • Locked
  • Question
DB2 Table size and DB size Issue
Replies
0
Views
35
Milind Taralkar
Milind Taralkar
Pack10
  • Locked
  • Question
IBM mainframe password changing.....
Replies
8
Views
34
Pack10
Pack10
msddcb
  • Locked
  • Question
How to reduce size of DB2 log file c0000000.lrg
Replies
1
Views
87
sathyarams
sathyarams
ifxos390
  • Locked
  • Question
OS390-->DB2 Volume size decrease
Replies
0
Views
11
ifxos390
ifxos390
sqlmann
  • Locked
  • Question
[b] Need to invrease the size of decimal [/b]
Replies
4
Views
21
MarcLodge
MarcLodge

Part and Inventory Search

Sponsor

Back
Top