Filesystem advice for DB2 Linux.

[Paul Reddin]

Hi,

Does anybody have any good links/advice on filesystem considerations
for DB2 Linux ?
e.g journalling options of ext3, relative performance of ext3,jfs etc..

Thanks.

Paul.

[Philip Nelson]

Paul Reddin wrote:

Paul,

We use ext3 with default settings from a RH or SuSE install.

We've never tried JFS or ReiserFS.

Would be interested in an "science projects" you do on this !!!

Phil Nelson

(speak to you at GSE on 11th March ?)

[Paul Reddin]

I have been reading through the many parts of the following series on
Linux filesystems.

http://www-106.ibm.com/developerworks/linux/library/l-fs7.html

I'm still left pondering some filesystem strategy points, from a DB2
perspective on Linux?

I am trying to apply hard earned lessons on AIX JFS and make sure
that we use Linux journalling filesystems appropriately/tuned manner.

e.g
1.If I use ext3 (which we will,after everything I've read) which
journalling mode should I use?
2.Could/Should I use different modes for recovery logs and tablespaces?
3. Or is there a good case for going for something like JFS?

I guess all DB2 Linux benchmarks have been run on Raw devices?

Thanks.

Paul.

[Jurgen Haan]

Paul Reddin wrote:
> http://www-106.ibm.com/developerworks/linux/library/l-fs7.html
>

Hi, i read the above link (and some related links).
I found EXT3 to look very promising, especially the fact that it
journals Meta-Data and Data instead of just journaling Meta-Data like
JFS,GFS(?),XFS and ReiserFS do.

But I also noticed that the document was dated nov. 2001. Is this
situation still accurate? (couldn't make much of the changelogs of
certain filesystems)

Jürgen
-R-

[Steven N. Hirsch]

Jurgen Haan wrote:
> Paul Reddin wrote:
>
>> http://www-106.ibm.com/developerworks/linux/library/l-fs7.html
>>
>
> Hi, i read the above link (and some related links).
> I found EXT3 to look very promising, especially the fact that it
> journals Meta-Data and Data instead of just journaling Meta-Data like
> JFS,GFS(?),XFS and ReiserFS do.

You can configure ext3 for a number of modes, among them metadata-only.
There's some good information on journaling filesystems for Linux on
IBM Developerworks. Search for back articles.

Steve