Re: onmode -z question/comment

lclee@nntp.best.com (Lin-Chuan Lee) wrote: :onmode -z can only be run by informix/root. In our :current situation, 'security' rules require that :we (developers), the people closest to 'the action' :cannot become informix or root on the production machines. :Occasionally, through the wonders of ODBC, we get :hung threads that have data locked. Instead of :of simply running onmode -z XXX, we have to track :down the DBA to do this. :Bitch and moan: Informix should allow owner :of thread onmode'ed the session .. like Unix will :allow you to kill own process. Well, may be. However it sounds like you have some strange animal of an ODBC driver. You shouldn't ever get hung threads (with or without locked data). Check out the better ODBC drivers. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company