Re: Informix on RAID-5

Jeff Craig wrote: > > Does anyone have any sage advice regarding implementing an Informix > database on a RAID-5 system? I am wondering how best to use Informix > fragmentation in light of the fact that RAID-5 has already striped the > data across disks. Since a RAID-5 "logical" drive is composed of several > physical drives over which data is spread by the RAID software, should > I try to fragment across logical drives? Should I skip Informix > fragmentation for RAID-based data? I am not planning on putting the > write-intensive stuff (logical and physical logs, temporary chunks, etc.) > on RAID-5. > > All comments are appreciated. > > ------------------------------------------------------------------- > Jeff Craig | dbINTELLECT Technologies, Inc. > Senior Consultant | Golden, CO > | (303) 275-6954 ext. 8008 > | email: settler@dbintellect.com > | fax: (303) 275-2134 > ------------------------------------------------------------------- We have been working with 10 Sun's Storage Array with RAID-5 configuration. We did not use Informix fragmentation on those 10 storage arrays, and no performance problem so far. We have one server without RAID-5, and we applied fragmentation on it. It was slow util we add another CPU. We also have a one terabyte RAID-S connected to Sparc 2000 with 12 CPUs. We did apply fragmentation on it because it is a proprietary RAID-5. My guess is that for RAID-5 you don't need informix fragmentation. Chao Din