|
Problem IT02347
|
Status: Closed |
REDISTRIBUTE MAY MISPLACE (ADD NODE) OR LOSE (DROP NODE) EXTENDED RECORDS FROM A TABLE WITH EXTENDED ROW SIZE SUPPORT |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Setup:
- DPF
- table with extended row size support
- REDISTRIBUTE with NOT ROLLFORWARD RECOVERABLE option
Problem only affects some records for which the physical data
row length exceeds the maximum record length for the table
space(extended rows).
Records that do not exceed maximum record length of the
tablespace are not affected.
Only small subset of extended length records are affected. It is
difficult to determine upfront whether a record will be affected
or not.
1. After performing successful REDISTRIBUTE ... ADD NODE
operation some extended length records that belong to a
different node according to new partition map are not moved by
REDISTRIBUTE operation. Thus they are on wrong node and may not
be returned by queries that perform node elimination.
2. After performing successful REDISTRIBUTE .. DROP NODE
operation some extended length records that belong to a
different node according to new partition map are not moved by
REDISTRIBUTE. If these records are on node that is about to be
dropped, they will be removed from table completely. This action
cannot be undone.
To diagnose the problem #2 run SELECT COUNT(*) before and after
REDISTRIBUTE operation. If number of records returned is
different - some records are lost. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DPF only, REDISTRIBUTE with NOT ROLLFORWAR RECOVERABLE *
* option *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 105. Fix Pack 4. *
**************************************************************** |
| Local Fix: |
Run REDISTRIBUTE without NOT ROLLFORWARD RECOVERABLE clause. |
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 10.5 Fix Pack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.06.2014
08.09.2014
08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
