|
Problem IC64067
|
Status: Closed |
DB2 CRASHES DURING LOAD WHEN A PREVIOUS LOAD USING VENDOR SORT FAILS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
15.12.2009
15.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
