Re: Informix database records locked
Try SET LOCK MODE TO WAIT 30; in case there are transient locks stopping the
deletes. Are you POSITIVE there are no other sessions? Not even your own or
some old ones hanging around? What does onstat -g ses say?
Art S. Kagel
----- Original Message -----
From: Alan Casey <alancasey10@eircom.net>
At: 2/26 13:46
> I haev Informix Server 7.3 installed on Win NT and I want to delete records
from
> a table but it keeps sayibng the recorda are locked (107:ISAM record, record
is
> locked and 244: could not do a physical order read to fetch next row).All
other
> users are not logged in. How do I unlock the tables or initialize the
database?