|
Problem IC61892
|
Status: Geschlossen |
DB2 CRASHES DURING LOAD WHEN A PREVIOUS LOAD USING VENDOR SORT FAILS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - 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: *
* DB2 V9.5 *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 crashes with signal # 11 during LOAD when a previous *
* LOAD *
* using vendor sort fails. *
****************************************************************
* RECOMMENDATION: *
* First Fixed in DB2 V9.5 FP5 *
**************************************************************** |
| Local-Fix: |
1. Avoid using third party sort tool
2. Recreate indexes without INCLUDE columns |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 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 |
Avoid using third party sort tool |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC64067
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.07.2009
22.12.2009
22.12.2009 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.5
|
 |
