By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,649 Members | 2,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,649 IT Pros & Developers. It's quick & easy.

Is it possible to "enable" auto-rollback functionality whiledead-lock occurred on DB2/400?

P: n/a
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~
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Supplementary:

The session A and B both shown the error message without rolling back
on one of transactions.

As I re-did the step 3) and 4) the error message was threw again. I
had to run SQL 'rollback' or 'commit' explicitly then the query just
could done.

Conversely, it will rollback one of transactions between session A, B
in DB2 for LUW. That is why I said DB2/400 seems not able to auto-
rollback one of transactions while dead-lock occurred.

So, is DB2/400 possible to "enable" auto-rollback functionality while
dead-lock occurred?
Thanks in advance~
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.