Re: Informix Daemon

td wrote: > > I know enough about informix, to know that I need to know more. Brief > scenario of the situation: Running Informix Version 5.10.IU1 on a Sun > Sparc box. Modems are 14.4, 28.8 and a T1 line. Portmaster connections, > have a 128 Informix user license (but I have never seen the users go > over 90). We did a Y2K upgrade on 2/4/99 to the current version. Since > that time we are getting multiple login failures and our Informix Daemon > go off_line. My first question is "What exactly is an Informix Daemon?" > My second question is, "Can the fact that a user logs off the system > incorrectly cause this Informix Daemon?" > Backround on the System to somewhat complete the picture. This is a > Multiple Listing Service, that has a large database. I am just trying to > glean any information I can, because the support team has given me > nothing but bull shit since we did the compliance upgrade. > If you would like to e-mail me, my address is tracyd@lbr.org. Any help > will be gratefully accepted. The Informix daemon, or tbinit for 5.xx, is the engine monitor. Since in 5.xx each user effectively has his own copy of the database running (sqlturbo) there needs to be a monitor to prevent problems between all of these processes, tbinit is it. If a client program exits, ^C's, or looses their connection to the database (like powering off their PC or quiting windows while the app is connected) the sqlturbo will exit as well but without neccessarily cleaning up completely. To prevent any database damage or data loss the tbinit will, in this case, shutdown all sqlturbos and the engine data structures as cleanly as possible immediately. Solution: Upgrade to 7.3x which does not suffer from this problem. This has always been a 5.xx problem but it is possible that 5.10 is better at detecting defunct connections from remote clients. Something that caused other problems with earlier 5.xx versions was the poor disconnect detection. Such a fix would explain why you are seeing this more often. Meantime, until going to 7.3x, beat up on the users to always exit gracefully from the applications before shutting down their PCs. Art S. Kagel