Subject Deadlock and wait
Author Marcos Vinicius Dufloth
Please, could somebody help me with this?

I start an transaction this way (script running at isql):

set transaction wait isolation level read committed no record_version;

insert ...
insert ...

commit;

When running two process or more, I get some few errors:

Statement failed, SQLCODE = -913

deadlock
-update conflicts with concurrent update


Of course that these inserts are (via triggers) updating same records sometimes, but, if I using WAIT, why this error still generates? Lock manager don't would keep waiting? I missing something?

TIA.
Dufloth.









[Non-text portions of this message have been removed]