Re: Locked out in exclusive mode

Run onstat -u You will see information about the SQL threads currently running.In the records where user is the one that you are are using note if the flag in position 1 in the flags field is Y (the thread is waiting). For this records get the session that holds the locks from the session field. Now run onmode -z session_id with the selected session_id to kill the not responding session holding the locks and tcom Newsgroups wrote: > > Hello > > While connected to a database in exclusive mode, my connection was lost and > I crashed out. I cannot now use the database as it is 'in use by another > user' (trying to connect gives errors 425: Database is currently opened by > another user. and 113: ISAM error: the file is locked). > How can I bring the db out of this lock and be able to connect again? I > urgently need to reconnect. > > Any help would be much appreciated. > > (I'm using Informix-sql 4.20UC3, Engine SE 5.10UC1 running on SCO Unix) > > My e-mail adress : ckipp@itad.co.uk