"Dead" user threads

Posted in 2000

Nick — Wed, 05 Apr 2000 15:40:44 GMT — source: Informix-list mailing list archive (1991-1998)

Hello, all. ARCHITECTURE: server-side: Informix DS 7.31 under SCO Unix 5 client-side: programs written in PowerBuilder 6 under Win95/NT PROBLEM: Sometimes, e.g. when client-side program crashes, the corresponding user thread on server is not removed (it is present in the ONSTAT -U output). So this thread need to be killed manually with ONMODE -Z. If that thread has locked some resources then it may be a serious problem. How to configure DB server so that to automatically remove such user threads. Thank you in advance. Sorry for imperfect English. KNN Sent via Deja.com http://www.deja.com/ Before you buy.