Re: latch problem
Stefanie Vario wrote: > > I have a client who is on a Sun Sparc 2000 running SunOS 5.X (I believe) and > Informix 5.03.UC1. The engine keeps coming down on a latch error. They get > the message "Process aborted abnormally (latch). Online must Abort." in > their message log. > > They get to their application via a Windows terminal emulation package using > a modem. When they login to the Sun, they automatically get put into a > 4GL program that displays a menu. When they're finished with their work, they > just exit out of the terminal emulation program which hangs up the modem. > At the time of the hangup, they're still in the 4GL program. Many times this > will cause the engine to come down on the latch error. We've put code into > the 4GL program to trap for various kill signals and found that the 4GL > is getting a kill -1 which should not be bringing the engine down. We've also > added code to do an "sqlbreak() and sqlexit()" when it receives some of these > kill signals so that it can (hopefully) do some cleanup but it doesn't seem > to help. > > We've already tried to tell the users to exit out of the 4GL program first, > but many times they forget. There's about 200-250 users on at any one time. > > Next, we're going to try to do a kill -13 on the associated sqlturbo when we > get this kill -1 signal. Call the 4GL program from within a shell script. Then set a 'trap' at the top of the shell script. I don't have the details to hand, but take a look at 'man trap'. If you don't have a manual entry for 'trap', then look at 'man sh' and search for trap. It is quite often a built-in. Depending on how you code it depends on whether it traps within the 4GL program. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+