|
Problem IC95947
|
Status: Geschlossen |
-901 IN REDISTRIBUTE ABORT AFTER SUCCESSFUL REDISTRIBUTE ABORT/CONTINUE WITH EXCLUDE KEYWORD. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
The problem is specific to EXCLUDE clause on ABORT/CONTINUE
operation.
There are two similar problems, both lead to complete table
data loss.
1. If two tables have to be recovered, then a successful
recovery of just one (second is EXCLUDEd) clears recovery info
about the second one. The second table is left in limbo - it
can't be
recovered from redistribute, and can't be accessed.
2. If two tables have to be recovered, but one failed when
redistribute was going in CONTINUE direction and another failed
when redistribute was going in ABORT direction, then
redistribute recovery can't recover one of the two.
==
Sample scenario (assume two tables, t1 and t2):
REDISTRIBUTE ADD NODE - failed while redistributing table t1
REDISTRIBUTE ABORT EXCLUDE T1 - failed while redistributing t2
At this point both tables require redistribute recovery, and
either recovery info from one of them will be removed (if
EXCLUDE clause is specified), or only one is recovered (if no
EXCLUDE clause is specified). |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DPF *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 101 fp4 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
Error -6056 with reason code 17 is returned. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 13.09.2013
02.06.2014
02.06.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.4
|
 |
