Re: Informix 7.X and RAID 5

Robbie Bailey (robbieb@crl.com) wrote: : I have some confusing info indicating that RAID 5 is not suggested/supported : in 7.X? : Anyone have some insights? : Rb. 7.1 gives you the option of fragmenting your tables across multiple devices via the use of multiple dbspaces. You can fragment in a round-robin fashion or invent an alforithm of your choice to specify which fragment the data lands on. The benefit of using fragments, combined with parallel data queries, are numerous. For instance, a single query can be decomposed into sub tasks and executed simultaneously, reducing the amount of time needed to answer the question. Multiple users accessing the same table benefit for the same reason and because multiple sets of r/w heads are servicing their tasks. Using raid disk can actually undue the fragmentation you are striving for because of the inherent striping being done at the hardware level. ================================================================ Michael T. Reed, DBA, Radiix, Inc. | email: mreed@radiix.com 3588 Plymouth Rd. Suite 257 | voice: 313-677-UNIX Ann Arbor, MI 48105 | fax : 313-677-UNIX