I am running DB28.2 on SLES 10. I was executing a Reorg on a very large table, and for some reason the reorg hung. After 7 hours waiting, I tried cancelling the application, but it wouldn´t stop, so I stopped the instance and started it again. The are currently no active applications running and no locks on the table, but when I try to execute any command (select, reorg, drop, etc...) it returns:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
How is this possible, there are no applications actives and no locks are shown when I run db2bp. How can I bypass this problem, or try to remove a deadlock that doesn´t exist.
select, reorg , drop etc r u executing against the table in which the reorg is hung, what is mode ur running the reorg offline online, chk in wht phase the reorg is using db2pd if it has crossed the build phase then you need to wait to till it get finished.