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

DB2 Linux settings (cache/buffers/IO)

P: n/a
Hi. I'm running a DB2 8.2 install on a X86_64 SuSE install.
The tablespaces and logs are stored on a netapp filer through an NFS mount.

Now I came across this article:
http://www-128.ibm.com/developerwork...dm-0509wright/

In that document the possibility of Direct I/O is given to improve
performance. I was wondering if this would also apply to NFS shares (NFS
being a virtual disk etc).

Furthermore, what's the best strategy to pursue on buffer allocation?
How can I best minimize the use of linux buffers? (thus increasing the
use of DB2 allocated memory?)

-R-
Mar 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Mar 8, 9:12 am, Jurgen Haan <jur...@fake.domwrote:
Hi. I'm running a DB2 8.2 install on a X86_64 SuSE install.
The tablespaces and logs are stored on a netapp filer through an NFS mount.

Now I came across this article:http://www-128.ibm.com/developerwork...rticle/dm-0509...

In that document the possibility of Direct I/O is given to improve
performance. I was wondering if this would also apply to NFS shares (NFS
being a virtual disk etc).

Furthermore, what's the best strategy to pursue on buffer allocation?
How can I best minimize the use of linux buffers? (thus increasing the
use of DB2 allocated memory?)

-R-
Set - db2set DB2LINUXAIO=true.

Turn off file system caching.

I don't think I would have database data files on a NFS mount.

Buffer allocation depends - But I have seen good results from 1
bufferpool for each of my database page sizes and 1 for large temp
page size.


Mar 8 '07 #2

P: n/a
On Mar 8, 11:30 am, "dunleav1" <j...@dunleavyenterprises.comwrote:
Set - db2set DB2LINUXAIO=true.

Turn off file system caching.

I don't think I would have database data files on a NFS mount.

Buffer allocation depends - But I have seen good results from 1
bufferpool for each of my database page sizes and 1 for large temp
page size.
What about long tablespaces that contain LOB or LONGVARCHAR data that
do not use bufferpools, and are synchronously accessed from disk each
time?
Mar 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.