aj wrote:
> DB2 LUW v8.2 FP 14 RHAS 2.1
>
> Not trying to start a flame war or anything, but does anyone have an
> opinion regarding whether to use Raid 5 or Raid 10 w/ DB2?
>
> We have an EMC SAN (a Clariion CX600 I believe). My SysAdmin and I
> are discussing which raid type to use. Several years ago during my
> Informix DBA days, Art Kagel and other well-informed folks on C.D.I.
> would occasionally point out how raid 5 w/ database is a BAD idea, and
> how raid 10 should always be used.
>
> With SAN advances (cache, memory, speed, etc..), does this still apply?
> My SysAdmin thinks Raid 5 is a better way to go.

NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!!

This is still true and likely always will be. Performance asside (and
noone's proven to me yet that massive cache eliminates more than half of the
RAID5 write penalty) the data safety issues are HUGE and noone's solved them
yet (only DG - now part of EMC - tried and their solution didn't work). At
the cost of drives today RAID5 no longer makes sense! Please read ALL of
the related articles posted on www.baarf.com, including my own, and read the
comments on the 'Baarf members' page from the many who've been bitten, and
see why everyone, not just DBAs, should avoid RAID5 like the plague.

> All of my tablespace containers are DMS (typically 2 gigabytes each),
> except for temp space, which are SMS.

Art S. Kagel

NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!!