Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    104

    Unanswered: deadlocks in db2 8.2

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You can also use the REORG command to just convert the indexes to type-2:

    REORG INDEXES ALL FOR TABLE MyTable CONVERT

    Andy

  4. #4
    Join Date
    Mar 2006
    Posts
    104
    The problem is fixed after doing reorg indexes all for table <..> convert.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •