Re: GPF without ROLLBACK on PC leaves locks on our 7.1 on-line server

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