RAID5 striping

[Stanley Sinclair]

I have a db2 database with tablespaces of several pagesizes. It is to
be placed on a new server with a RAID 5 configuration.

I am told that neither striping size, nor any other configuraton issue
of the RAID array has any effect on the database as far as pagesize is
concerned. In other words, a tablespace of 4K and a tablespace of 32K
will be well served simultaneously. (I realize that prefetch etc will
be affected.)

Is this true?

SS

[Mark A]

"Stanley Sinclair" <st*************@bellsouth.net> wrote in message
news:6f*************************@posting.google.co m...

I have a db2 database with tablespaces of several pagesizes. It is to
be placed on a new server with a RAID 5 configuration.

I am told that neither striping size, nor any other configuraton issue
of the RAID array has any effect on the database as far as pagesize is
concerned. In other words, a tablespace of 4K and a tablespace of 32K
will be well served simultaneously. (I realize that prefetch etc will
be affected.)

Is this true?

SS

Extent size and prefetch size (which should be equal to or a multiple of
extent size) are affected by stripe size.

[Stanley Sinclair]

"Mark A" <[e-mail]> wrote in message news:<bA***************@news.uswest.net>...

"Stanley Sinclair" <st*************@bellsouth.net> wrote in message
news:6f*************************@posting.google.co m...

I have a db2 database with tablespaces of several pagesizes. It is to
be placed on a new server with a RAID 5 configuration.

I am told that neither striping size, nor any other configuraton issue
of the RAID array has any effect on the database as far as pagesize is
concerned. In other words, a tablespace of 4K and a tablespace of 32K
will be well served simultaneously. (I realize that prefetch etc will
be affected.)

Is this true?

SS

Extent size and prefetch size (which should be equal to or a multiple of
extent size) are affected by stripe size.

Then, to repeat for my certainty: except for extent and prefetch
sizes, db2 doesn't care about the stripe size of the disk array.
Multiple tablespaces of different page sizes will coexist in harmony,
oblivious of the striping (or number of disks, or any other physical
characteristic) of the array. Right?

Thanks.

[Mark A]

"Stanley Sinclair" <st*************@bellsouth.net> wrote in message
news:6f**************************@posting.google.c om...

Then, to repeat for my certainty: except for extent and prefetch
sizes, db2 doesn't care about the stripe size of the disk array.
Multiple tablespaces of different page sizes will coexist in harmony,
oblivious of the striping (or number of disks, or any other physical
characteristic) of the array. Right?

Thanks.

Yes, except that page size effects minimum extent size.