DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 Engine may trap in  SQLULIGN() while Loading data from IXF 
file 
 
Here is a sample stack: 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x000000000000F410 ?unknown + 0x0 
0x090000000827AA28 sqlulign__FP8sqluiiwaPP8SQLUIILTi + 0x580 
0x09000000082847B8 
sqlulirr__FP8sqluiiwaP8sqeAgentiPP10SQLD_VALUEUi + 0x194 
0x090000000837FD28 
@146@sqluGetAndFormatRecords__FP8sqlulacbP13SQLUCACB_TYPEP17SQLU 
_FORMATTER_CBUiPPUciP10sqlz_valuePUcPP10SQLD_VALUET9Pi 
+ 0x8D8 
0x090000000837925C sqluldat__FPUcUi + 0x17F0 
0x0900000005DF2A14 sqloEDUEntry + 0x49C 
</StackTrace> 
 
This apar will address the following: 
1) Fix One Specific Condition that leads to this trap. 
2) Add Defensive Code to avoid this trap 
3) Add diagnostic messages to dump additional information if the 
issue occurs inspite of (1) and (2) above

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 ENGINE MAY TRAP IN SQLULIGN() WHILE LOADING DATA FROMIXF * 
* FILE.Here is a sample stack:<StackTrace>-------Frame------   * 
* ------Function + Offset------0x000000000000F410 ?unknown +   * 
* 0x00x090000000827AA28 sqlulign__FP8sqluiiwaPP8SQLUIILTi +    * 
* 0x5800x09000000082847B8sqlulirr__FP8sqluiiwaP8sqeAgentiPP10SQL 
* +                                                            * 
* 0x1940x090000000837FD28@146@sqluGetAndFormatRecords__FP8sqlula 
* 0x8D80x090000000837925C sqluldat__FPUcUi +                   * 
* 0x17F00x0900000005DF2A14 sqloEDUEntry +                      * 
* 0x49C</StackTrace>This apar will address the following:1)    * 
* Fix One Specific Condition that leads to this trap.2) Add    * 
* Defensive Code to avoid this trap3) Add diagnostic messages  * 
* to dump additional information ifthe issue occurs inspite of * 
* (1) and (2) above                                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to version 9.7 Fixpak 2 or later              * 
****************************************************************

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 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a 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
 

Problem is first fixed in Version 9.7 Fixpak 2

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

17.02.2010
22.06.2010
22.06.2010

9.7.