Hi all,
Just wanna share some experices with you. We have experienced deadlock
problems after we migrated our DB2 v7.x to v8.x. And we are using WAS
5.x and WCBE 5.5 at the same time.
It tooks us days to find the root cause. By reading this post,
hopefully it won't cost you that much.
The root cause of the problem is "restore db" only restores type 1
indexes to type 1. In V8.x, DB2_RR_TO_RS=YES is deprecated for Type 2
Index. I didn't find the officical document from DB2 info center.
However, I tried this trick on AIX 5.1, DB2 V8.1.1.16 and seems no
longer supported there.
To fix the problem, we need to run reorg for every table to convert
type 1 index to type 2 after we restore the v7 database.
such as
REORG INDEXES ALL FOR TABLE <FOO> CONVERT;
and it does solve the deadlock problem.
cheers,
Victor