|
Problem IC64067
|
Status: Geschlossen |
DB2 CRASHES DURING LOAD WHEN A PREVIOUS LOAD USING VENDOR SORT FAILS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
DB2 crashes with signal # 11 during LOAD when a previous LOAD
using vendor sort fails.
Crash only occurs if
1. A third party vendor sort tool is used and
DB2SORT registry variable is pointing to the vendor library
2. The table has index that has include columns
3. This table index is marked bad due to a previous LOAD
failure. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* v9.7 FP0 *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 crashes with signal # 11 during LOAD when a previous *
* LOAD using vendor sort fails. *
****************************************************************
* RECOMMENDATION: *
* First Fixed in V9.7 FP1 *
**************************************************************** |
| Local-Fix: |
1. Avoid using third party sort tool
2. Recreate indexes without INCLUDE columns |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Crash only occurs if
1. A third party vendor sort tool is used and
DB2SORT registry variable is pointing to the vendor library
2. The table has index that has include columns
3. This table index is marked bad due to a previous LOAD
failure. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.10.2009
15.12.2009
15.12.2009 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
