Re: Online Row Level Locking

Jim writes... > > This is a known design issue with Online.... > My understanding is that in V6 the locking strategy is changing and > Informix are extending the locking mechanism to be able to hold locks > on values that don't currently exist in the indexes. This means that > V6 will be able to hold a lock on 50 even after the index entry has > been removed. The lock tests will also change, instead of testing > that the next higher key is not locked on an insert of a new or > updated key, Online will test whether the index value is locked. > Hallelujah! This, and the long transaction rollback problem, have been the major cause of problems for my clients in the past two and a half years. Paul Hatcher phatcher@cix.compulink.co.uk