Re: locking

Hi, ants: The repeatable reads tend to lock all rows during the transcations, probably even lock the whole tables when the query paths are not using index search. So, it is obvious repeatable reads cost much more locks and tend to cause deadlock. But, the locks will remain if they are not causing deadlocks even through they might last longer than deadlock time parameters. Regards ANTS <sui@naseej.com> wrote in article <6e1dbo$bpd$1@news.xmission.com>... > > Hi, > > We have a 4GL program whenever it runs it will lock several tables. The > problem is that the lock will remain long enough more than the deadlock > timeout parameter. Why? and the other ppl's work will be locked as well. > > The isolation level is set to repeated read, is that appropriate? > > Regards, > > Nien