Re: Compaq tell me I cannot use hardware raid and raw disks with informix

Stephen Gill wrote in message <01bd5e66$9b6059e0$1ea6010a@default>... >Can anyone advise? > >I'm told me tech support at compaq that I cannot setup a hardware raid >configuration ie logical mirrored disk of say 9 gb, with informix, using >the raw disk device I've set up. They claim that it would corrupt the data. > In general, Informix does not like raid. It will run on raid with no problems (or data corruption or loss - if setup correctly). There are performance implications though. Through precise DBSPACE and table positioning you can optimize Informix to have maximum spindles available on large tables. This is the case with raid. Yes you can create one DBSPACE to span 4 spindles using raid, but the second spindle will only be used once the allocated space on the first has been used up. Further, it is advisable to use the Informix mirroring method above any other logical method. Online 7 will optimize to use mirror disks with the primary disk in executing SELECTS, so doing also increasing performance.