Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <4q57m4$44s@portal.gmu.edu>, ANDRZEJ ZALESKI
<azaleski@osf1.gmu.edu> writes
>Hi,
>I wonder if somebody has a clue whether this is correct or not:
>We use INFORMIX 7.1 Dynamic On-Line server on Unix RS-6000 computer.
>Front-end is Powerbuilder 4.03 and MS-Windows 3.1. We noticed that if
>there is GPF on the front-end during transaction, there is no
>automatic rollback on the Informix server. Even switching off the PC
>and waiting for hours does not help at all. Only database administrator
>can unlock such table. Is this the way it should be?
>
>Best Regards,
>Andrzej
>
I am assuming you have a TCP/IP network, in this case you need to set
the keepalive timer to something less than the default which is 2
hours. The Informix server is waiting for a response from the PC and
never gets one because the PC has died. There is no way that the
Informix server can ask to be informed when the PC 'dies'. A
limitation of TCP/IP I believe.
--
David Williams
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.