Re: Planning an Informix Database disk layout

In article <6vb7k1$krp$1@news.xmission.com>, david.g.wilson@nz.eds.com (Wilson, David G) wrote: > > Hi everyone.... > > > Can anyone advise me if there have been any articles written, and ae > available on the web, about a disk layout strategy? We are in the > process for planning the disk layout of a 150Gb system with 300+ tables. [cutting] You don't mention Informix version. hardware, the application type etc but .. If you can afford not to use RAID 5 then don't, and steer clear of software based RAID, stick to hardware based. Personally I'd aim for lots of disks on lots of channels as a starting point. I also like lots of tempdbspaces, I like to ensure PSORTTEMP points to 'memory' file system rather than a disk based filesystem. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 # www.wfsoftware.co.uk