Re: How to find and remove exclusive lock on table or row

I guess you are trying to identify the user/thread that is using the exclusive lock and want to kill/remove the process that is using the lock without shutting down the server ?? Well, using onstat -k will give you the relevant lock information, you will then need to use onmode -Z or onmode -z to clear the session/address of the thread that is using the lock. Sean Aik Khoon wrote in message <7b0qqv$gig$1@mawar.singnet.com.sg>... >Hi , > >I've been trying to find out how to locate information on exclusive lock >(is onstat -k enough) and disable it besides shutting down the IUS server. > >Thanks, >Aik Khoon > >