Hi

We use DB2 UDB on windows 2000.

Our porduction database used to run OK in version 7.2.5. We migrated to db2 8.2.6 recently and are getting 6 to 10 dead locks in a day. The table indexes are still type 1 indexes. Can it be the cause for this?

Any help will be much appreciated

If you reorg the tables (not inplace reorg) the indexes will be converted to type 2. You should do this first before persuing any other causes.

If the tables are too large to reorg, then I would just drop and recreate the indexes.

You can also use the REORG command to just convert the indexes to type-2:

REORG INDEXES ALL FOR TABLE MyTable CONVERT

Andy

The problem is fixed after doing reorg indexes all for table <..> convert.

Thanks