By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,745 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

faster CPU vs more RAM

P: 1
I'm investigation what we need for an up coming project. We will be using DB2 v9 and exploiting its new XML feature. How does a faster CPU or more RAM influence db2 performance
Aug 31 '07 #1
Share this Question
Share on Google+
1 Reply


docdiesel
Expert 100+
P: 297
Hi,

classically it may be said that any database is living on RAM. More CPU is welcome, but RAM is necessary. (E.g. my first aim to speed up a db2 database is to increase the bufferpool(s).)

Btw., make sure you'll work with the 64bit edition, not the 32 bit because the latter one has some limitations. 32bit system means max. 4 GB address space, from which db2 uses max. 2 GB for bufferpools etc. (See also this article about db2's memory architectures on different system at http://www.ibm.com/developerworks/db...6qi/index.html.)

Regards, Bernd
Aug 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.