Oninit cdi / Archive
Talk to an expert →

Syslocks table

Posted in 2004

Topics: General Discussion

Vasilis Economides — — source: Usenet: comp.databases.informix

I am running a procedure and within a procedure I have an insert. Even though there are no other sessions running I get the error 271 Isam 144 (locked table). I checked the syslocks table and the type of lock is IX. Any idea why this happens? Thanks, Vasilis

↪ replying to Vasilis Economides
Art S. Kagel — — source: Usenet: comp.databases.informix

On Mon, 12 Jul 2004 03:07:29 -0400, Vasilis Economides wrote: Does it happen the first time you try running the procedure or the second? Are you testing in dbaccess? Using the Query menu? From multiple sessions? Dbaccess begins an implied transaction for you. If you did not commit it, the original session will be holding a lock. Art S. Kagel > I am running a procedure and within a procedure I have an insert. Even > though there are no other sessions running I get the error 271 Isam 144 > (locked table). > I checked the syslocks table and the type of lock is IX. > > Any idea why this happens? > > Thanks, > > Vasilis

Related threads