|
Problem IC97535
|
Status: Closed |
POSSIBLE SEGV (CRASH/TRAP) IN SQLDROWFETCH() WHEN SQL IS USING PBT(Parameterized Base Table) ACCESS IN A NESTED LOOP JOIN |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
It is possible for a SQL statement to generate a segv in
sqldRowFetch() while executing
a join using PBT access. The top of the stack would show the
following functions:
0x090000000756256C sqldRowFetch
0x0900000007577A7C sqlriFetch
0x0900000007A767BC sqlriNljnNonPiped
This problem would not happen in v9.8 and v10.1. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* It is possible for a SQL statement to generate a segv in *
* sqldRowFetch() while executing *
* a join using PBT access. The top of the stack would show the *
* following functions: *
* *
* 0x090000000756256C sqldRowFetch *
* 0x0900000007577A7C sqlriFetch *
* 0x0900000007A767BC sqlriNljnNonPiped *
* *
* Close Code *
* *
* *
* Name *
* *
* Reason Code *
* *
* *
* Release *
* *
* Return Code *
* *
* *
* Fix Rel. *
* *
* *
* Failing Module *
* *
* *
* Failing Level/SU *
* 950N *
* *
* => *
* *
* *
* Test Rel. *
* *
* *
* Support Code *
* *
* *
* Original APAR *
* All *
* *
* Users Affected: (describe the specific software/hardware *
* environment in which the problem occurs) *
* NONE *
* *
* SRLS/Documentation *
* NONE *
* *
* Modules/Macros changed *
* It is possible for a SQL statement to generate a segv in *
* sqldRowFetch() while executing *
* a join using PBT access. The top of the stack would show the *
* following functions: *
* *
* 0x090000000756256C sqldRowFetch *
* 0x0900000007577A7C sqlriFetch *
* 0x0900000007A767BC sqlriNljnNonPiped *
* *
* This problem would not happen in v9.8 and v10.1. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem fixed In 10.5.0.3 |
| Workaround |
N/A |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.11.2013
24.03.2014
24.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
