Re: lock problems

Posted in 1998

Terence P. Hillick — Wed, 04 Nov 1998 10:31:02 -0500 — source: Informix-list mailing list archive (1991-1998)

Is the database session still running,( i.e. ontstat -u), if so then terminate it onmode -z [sessionid]. This may take a few minutes depending ofcourse on what the sesison was doing, how long to roll back etc. Terry Hillick VP, CSCS, Inc. ProzessDV wrote: > We have OWS 7.22 on SCO UNIX and Windows 95 clients. When a program on a client > PC locks a table (in exclusive mode) and this client crashes for any reason (as > it happens sometimes with W95), the table is still locked. We have to restart > the database server to reset the lock. Is there any other possibility than to > restart the database server on a running system? > > Thanks for help, > Chris