Hi,
DB2/400 seems not able to auto-rollback one of transactions while
dead-
lock occurred.
I called the procecure QSYS.CREATE_SQL_SAMPLE for creating sample
database, and used ISQL (STRSQL) & Navigator (Run SQL Scripts) to
evaluate it:
Session A (Isolation Level = CS):
1) insert into sampledb/staff values(1,'Ofer',1,'Mgr',0,0,0)
3) select deptname from sampledb/department
Session B (Isolation Level = CS):
2) insert into sampledb/department values('1','System
Monitor','000010','A00',NULL)
4) select name from sampledb/staff
The conclusion is:
In ISQL, it shown CPF5027 (error code is 2) and QRY5050 (2 times); In
Navigator, it shown CPF5027 (error code is 2, 2 times) and SQL0913.
But, no rollback occurred on any transactions automatically.
This behavior is not the same as the "open" db2 does.
Is it possible to "enable" auto-rollback functionality while dead-lock
occurred?
Thanks in advance~