Re: Moving a DB from SCO to Sun and RAID 1+0 config help

From: Gary Quiring <garyq@emcosales.com> > >We finally got the go ahead to separate the applications from the Informix >7.3 DB. We currently are running everything on a SCO OpenServer Raid 5 box >with 75 gig. Due to Art K posts about RAID 5, we convinced mgmt to split >the load and do a raid 1+0. > >The bad news is no one over here is an Informix DBA. We are all newbies at >this. > >My question is how many stripes should I configure. The Sun box will have >200gig of usable space with raid 1+0. Should I make the 200 gig one large >disk of all 2 gig chunks? Or should I have 3 striped drives, one for >rootdbs, logs and the last for data? Tough call. 200GB is about the margin point for me. Less than 200Gb and I generally treat disks as singleton drives to maximise throughput out of placement. A1000 or D1000? Or A5000? 9 or 18 GB disks? Maybe try this: 1 disk for rootdbs 1 disk for plogdbs 1 disk for llogdbs 1 (or 2 or 3) for tempdbs's remainder in one stripe for data. Or: 1 stripe for root, plog and llog (relatively small) 1 stripe for temp 1 stripe for data >The Sun is also new to us, so should I be ordering Veritas Volume Manager >to handle all those 2 gig chunks? Yep. >Last question (for now), what software besides 7.3 engine is needed on the >Sun box. There will be no apps on it, just the DB. Nothing I can think of. Client SDK, maybe. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com