|
Problem IC62929
|
Status: Closed |
DB2 ENGINE MAY TRAP IN SQLULIGN() WHILE LOADING DATA FROM IXF FILE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 Engine may trap in SQLULIGN() while Loading data *
* fromIXF fileHere 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: *
* Upgrade to Version 9.5 Fixpak 6 or higher *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.5 Fixpak 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66422 IC66423
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.09.2009
22.06.2010
22.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
