Row locking problems.
Hi: As I understand Informix SE does not have logging as Online have. I had no problems with row locking in SE and all programs worked perfectly, but with Online 7.30 I am really hving anightmare. I have tried to do the following in all sorts of combinations: - Setting wait to 10 - Alter tables to be Row Level locking (noting down that system tables cannot be altered in that way) - Setting isloation to DIRTY READ. I am still getting this record locked problem. Any other try? Rgds Denis Hung
In article <801f9v$sbs$1@news.intnet.mu>, Denis Hung <denis@bow.intnet.mu> writes >Hi: > >As I understand Informix SE does not have logging as Online have. I had no >problems with row locking in SE and all programs worked perfectly, but with >Online 7.30 I am really hving anightmare. I have tried to do the following >in all sorts of combinations: > >- Setting wait to 10 >- Alter tables to be Row Level locking (noting down that system tables >cannot be altered in that way) >- Setting isloation to DIRTY READ. > >I am still getting this record locked problem. Any other try? > Make all indexes unique. >Rgds >Denis Hung > > -- David Williams
Post a few more details and you could get a reply you could use - locked session's SQL, locking session's SQL (if you know), table(s) structure. Rudy Denis Hung wrote: > Hi: > > As I understand Informix SE does not have logging as Online have. I had no > problems with row locking in SE and all programs worked perfectly, but with > Online 7.30 I am really hving anightmare. I have tried to do the following > in all sorts of combinations: > > - Setting wait to 10 > - Alter tables to be Row Level locking (noting down that system tables > cannot be altered in that way) > - Setting isloation to DIRTY READ. > > I am still getting this record locked problem. Any other try? > > Rgds > Denis Hung