IBM Support

IC71763: REDISTRIBUTE ON RANGE PARTITIONED TABLES MIGHT DEADLOCK

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • A redistribute operation on a data partition group containing
    range partitioned tables might deadlock. This is due to a timing
    issue between the redistribute progress monitor and redistribute
    trying to update the tablespace state.
    
    The redistribute progress monitor will attempt to lock all
    tables to get the table size. When the redistribute agent starts
    working on a tablespace it will attempt to lock all tables in
    order to update the tablespace state to REDIST IN PROGRESS.
    Since the two agents lock the tables in different order it is
    possible with the right timing to hit a deadlock. The workaround
    is to interrupt the redistribute and issue a REDISTRIBUTE
    CONTINUE.
    
    The fix will be to serialize the redistribute progress monitor
    with the other agent so that they don't try to lock the tables
    at the same time.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * User running DB2 v970 FP3a or lower                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * REDISTRIBUTE ON RANGE PARTITIONED TABLES MIGHT DEADLOCK      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.70.FP4 or higher                            *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC71763

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-07

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC72939 IC75177

Fix information

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC71763

Modified date: 28 April 2011