Re: Large System

Blacker, Herb wrote: > > I'm looking for general performance characteristics (and any > tips/tricks) for anyone running a system similar to this one: > > Four (or more) 12-way 4GB S/70's (AIX 4.3) running OLTP (IDS 7.3x) with > 4000 max (1200-1500 concurrent) users. > We estimate total usage at somewhere near 600-800GB after a couple of > years running. > We'll most likely be running a single database with 1200 tables, > although it may be possible to break it up. > The rollout will be gradual, but completed by the end of '99. > We may also develop a data warehouse based on this application's data. > > Do I have enough/the right iron to do the job? > > Herb Blacker > Database Administrator > hhblack@prninc.com Hmmm... How will Informix 7.x and 4 AIX boxes fit together on one database?? Given that OLTP oriented DBMS's sink or swim on shared memory, and AIX is a major pain in the kiester shared memory wise, I don't like the way things look. Add in generally poor performance per dollar and you have a disaster looking for somewhere to happen. Lemme guess - a committee of non technical (or very inexperienced) types suggested this config cause they like playing golf with the IBM rep.... For a big nasty Informix based system, do yourself a favor, go with Sun/Solaris. Greg