Re: Advice for IBM SSA disks

We are using Informix Mirroring because in questions of performance and security there are no obvious advantages for AIX or Informix but it's more transparent to our database monitoring and I get an e-mail via the alarm- program when a chunk is down. To achieve a well balanced distribution we have created several dbspaces per disk and then distributed the tables across them. Now we check the io-statistics per chunk from informix and the iostat command from AIX to find bottlenecks and then use onunload/onload to move tables. For big tables we use special dbspaces for fragmentation across multiple disks. But beware: there are many factors to be considered when deciding on optimal fragmentation! Again: we have decided on Informix fragmentation vs. AIX striping because it's more transparent to us and to our db monitoring. Hope this helps. Cheers. Ralph. In article <6j6a60$d3d$1@news.xmission.com>, Zeljan Silje <zeljan@laus.hr> wrote: > > > Hi, > > my customers configuration is: > - AIX4.2 > - F50 machine (250 MB, 4x2.5GB + 4x4.5GB SSA disks, 1 processor) > - Informix OnLine7.23 > > SSA disks (no raid) will hold the customers database. I have to decide > how to spread database across SSA disks to provide balanced disk load > and to provide mirroring. > > I think I have two options for balance disks load: AIX striping and > Informix fragmentation. Does anyone have experience what shall be better > on such configuration? If I use AIX striping what stripe size shall I > use? > > If I decide on one of previous options, what mirroring is better: AIX > mirroring or Informix? > > Thanks in advance. > > +--------------------------------------------------------+ > | CC Computer Consulting d.o.o. | > +--------------------------+-----------------------------+ > | Zeljan Silje | e-mail: zeljan@laus.hr | > | CC Computer Consulting | Tel: +385 (20) 411-136 | > | Janjevska 15 | +385 (1) 6552-330 | > | 20 000 Dubrovnik | Fax: +385 (20) 411-136 | > | Hrvatska (Croatia) | URL: http://www.laus.hr | > +--------------------------+-----------------------------+ > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading