468,257 Members | 1,465 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

faster CPU vs more RAM

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
1 1496
297 Expert 100+

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.

Similar topics

36 posts views Thread by Armin Rigo | last post: by
23 posts views Thread by YinTat | last post: by
1 post views Thread by James dean | last post: by
12 posts views Thread by karthikbalaguru | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.