Re: Need help: zombie user threads

In article <D32E2w.9Cn@Yuri.CC.Uni-Augsburg.DE>, <sfk@teflon.RZ.Uni-Augsburg.DE> writes: > Newsgroups: comp.databases.informix > Path: massive!ncar!gatech!howland.reston.ans.net!Germany.EU.net!news.dfn.de!news.uni- augsburg.de!teflon.RZ.Uni-Augsburg.DE!sfk > From: sfk@teflon.RZ.Uni-Augsburg.DE (Rolf Saalfrank) > Subject: Need help: zombie user threads > Message-ID: <D32E2w.9Cn@Yuri.CC.Uni-Augsburg.DE> > Sender: news@Yuri.CC.Uni-Augsburg.DE (The News Administrator) > Nntp-Posting-Host: teflon.rz.uni-augsburg.de > Organization: Computer Center, University of Augsburg, Germany > X-Newsreader: TIN [version 1.2 PL2] > Date: Fri, 27 Jan 1995 12:44:55 GMT > Lines: 20 > > > We have a problem with our client server application as described > below: > Windows Application > -> Q+E ODBC driver V. 1.2 > -> Informix NET for Windows 5.01E1 > -> LWP Winsock interface > -> Network > -> Informix Online 6.00 UE1 under UNIX > Now the problem: > When our Windows client crashes, a user thread within Informix > remains alive with all its database locks. A checkpoint doesnt > help. We have to kill this thread manualy with the onmode command. > Any help is appreciated. > With regards, > -- > Rolf Saalfrank > PRO SIEBEN television Inc. > rolf.saalfrank@public.uni-augsburg.de > I've had a similar experience(s) with this problem using Informix OnLine and Viewpoint for Windows. I don't think there is a clean, cut, and dry solution to this problem. Rebooting regularly (or taking the Informix off-line) at off-peak hours (late night or weekends?) might work for you if you can do this in a cron job or something.