Re: Crashing clients, locked tables, sad users...

----- Begin Included Message ----- From ilist@rmy.emory.edu Mon Aug 28 18:22:36 1995 From: mobile@faui63.informatik.uni-erlangen.de (MOBILE-Testaccount fuer tagoesma) Subject: Crashing clients, locked tables, sad users... Date: 28 Aug 1995 15:27:38 GMT To: informix-list@rmy.emory.edu X-Informix-List-To: rt10hp@csl.gov.uk X-Informix-List-Id: <news.16598> We are using Informix 6.0 in a DEC/Alpha environment. Sometimes when a client crashes during a transaction, Informix doesn't notice that. As a consequence the referenced tables are locked. The question is how these tables can be unlocked again (by interactive commands). Thank you very much. Regards, Thomas ----- End Included Message ----- Not sure what a "DEC/Alpha" environment is, but if it's anything like UNIX, go to the directory where the database is, move down one level to the xxx.dbs directory (where xxx is the database name), and type : clearlok at the prompt. Hope this works on your system :-) Cheers, Richard. ----------------------------------------------------------------- | _ /\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | -----------------------------------------------------------------