Re: Locked Recrod / Killing a Process

John A combination of onstat -k (to find the userthread holding the lock), onstat -u (to find the session id for the userthread) and onmode -z sessid would have removed the user off the system. HTH Sujit John Leipold <jleipold@msn.com> on 09/23/99 03:14:35 PM Please respond to John Leipold <jleipold@msn.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Locked Recrod / Killing a Process I currently a 4GL consultant at a site with no DBA. We are running an Informix 7.2x engine on a Sun machine. One record was locked in a table today........ The solution was to kick off 500+ users, shutdown the machine, and restart the database. Now I am no DBA, but I'm sure that using tools provided under UNIX and Informix that you can track down the process that has the lock and ask the user to logoff or maybe as a last resort kill the offending process without taking 500 users down for 30 minutes. (I have seen ~real~ DBA's do this in the past) I was stunned to find out that even though we have Informix support, the thought never occurred to anyone to call and ask if some other solution was possible. I'm not sure if this would change anything but the record locked, was a stored procedure entry in the sysprocauth table. I am hesitant to kill processes that have anything to do with a system table, event to the slightest degree. Thanks in advance