Re: Informix Online 5.01 versus Online 7.x

In article <4q8q93$857@newsbf02.news.aol.com>, BGarrett1 <bgarrett1@aol.com> writes >We have Online 5.01 AND Online 7.1x running both on one Solaris 2.4. I >prefer 7.1x because I can look at actual SQL running to see if anyone is >doing anything "funny" (onstat -g sql), I have more flexibility in tuning >parameters and connectivity (don't have to worry about starting that silly >sqlexecd). AND (believe it or not) I actually like the "concept" of >onarchive although there are alot of improvements needed. I have had to >write scripts and I confiscated a special su "C" program to allow the >operators to circumvent that dreaded "you can only be root or informix" >message for backups or bringing down/up the database. I'd agree - more tuning ability, better connectivity - no Informix- STAR required, it is built-in!! Also there are more paramters to make it easier to tune. There are also less UNIX processes running under Informix v7. There is no longer one process per client connected, just one process (or maybe two or three for a server with > 250 users) which is multi-threaded and has one thread per client. This means much less switching between processes by the UNIX scheduler and less memory used. > Online 7.1x does >have some versions with more bugs than other 7.1x versions; and, you may >find some programs a little slower (especially if they don't stick to ansi >sql -- but, none of my databases are ansi defined. Get the latest versioin - 7.13 or 7.2 depending upon your plaform. Programs won't run slower if they do not stick to ANSI-SQL, but a few may find slower due to a different architecture under v7. Most will run faster especially under heavy load with many users connected. > I am still waiting for point in time recovery where I can recover up >to the "last sql" that caused a problem. I don't like having only "root" >install or upgrade Informix; it should allow "informix" to upgrade or >install. The recovery thing was one thing under consideration for v8. (This was from an Informix trainer on a course - it is not confirmed just was under discussion ~ June/July last year). > Anyway, that's my 2 dollars worth (inflation you know). Feel free to >send the money asap... I'm not independently wealthy, yet. Same here, preferably in 1000's so it's not too heavy to carry ;-> -- David Williams