IT29297: INCOMPATIBLE OPERATIONS OF EXTENT MOVEMENT AND REBALANCE RUN AT THE SAME TIME CAN CAUSE DATA CORRUPTION

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Data corruption occurs when incompatible operations of Extent
  Movement and Rebalance are executed at the same time. This is
  normally not possible as the ALTER TABLESPACE command while one
  of those operations is running will return SQL0290N. Under a
  certain timing window it is possible to start both operations at
  the same time. This APAR will be to restrict the execution of
  these incompatible operations at the same time.
  
  If Extent Movement and Rebalance are executing at the same time
  the tablespace will be in the following state (using db2pd
  -tablespace):
  
  0x10080000
  State = Move in Progress
        + DMS Rebalance in Progress
  

Local fix

• Avoid running Tablespace Extent Movement and Rebalance
  operations at the same time.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to v11.1 M4 FP4 or newer.                            *
  ****************************************************************
  

Problem conclusion

• Upgrade to v11.1 M4 FP4 or newer.
  

Temporary fix

Comments

APAR Information

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

  IT29257

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP