Re: Question for Sun experts

As far as 1 and 2, I'm unable to comment. But 3...... I'd recommend avoiding Solaris 7. We've recently upgraded from Solaris 2.5 to 7 and have encountered an interesting problem. System process are hanging. A pstack on the hung process will resume the execution. The processes affected most often are our cpu vps. We've also had times when the whole server will hang. Touching the keyboard/mouse on the console gets the thing moving again. (Shamefully, we've attached a vibrating pager to the mouse to accomplish this movement remotely. Only had to use this once. ) :) Sun is aware of the problem and I'm told it's fixed in 2.8 but we are currently waiting for a patch for Solaris 7(2.7). We've been able to keep the server running with scripts. The only time the database dies is when doing a binary unload and the cpu vp handling the unload hangs for an extended period of time. ... just my 2 cents.... Richard Walther Land O' Lakes, Dariyman's Division Bashar Chalabi wrote: > Hello, > > We are usually a PC shop (NT and SCO). One of our clients insists on having > a Sun server. They are horrified at the idea of PCs as servers. We have no > experience of Informix on Sun, so here are a few questions: > > The application is mainly OLTP during the day with around 200 users. At > night, there is a hughe batch run, written completely in stored procedures. > > 1. How does an UltraSparc II 400MHz compares with a Pentium III Xeon 500MHz. > I know they are better, but would a Dual UltraSparc replace a Quad Pentium? > > 2. We have to choose between the Workgroup Servers (450) and the Entreprise > Servers (3000). I assume the entreprise are faster machines, but the > processors are the same. Will a typical database application see much better > performance in an Entreprise server? > > 3. Is Informix 7.31 stable on Solaris 7, or is it better to stick to an > older Solaris. > > Thanks for any help.