|
Problem IC86557
|
Status: Closed |
POSSIBLE ABEND DUE TO DOUBLE FREE IN STMTHEAP MEMORY WHEN COMPILING A COMPLEX QUERY WITH MULTIPLE GROUP-BY SUBQUERIES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When compiling a complex statement with multiple
group-by sub queries, it is possible that the DB2 Query Compiler
will free the same internal memory structure twice.
When this happens, the problem goes undetected until the memory
is reused, during the same query compilation.
This may lead to a crash with possibly several signature call
stacks, a few that have been observed :
1.
sqlnr_pullup_rejoin_qun
sqlnr_pullup_compensations
sqlnr_subsume_derived_match
sqlnr_subsume_match
form_matches
2.
sqlnr_qncdereqc
sqlnr_optprep
sqlnr_optprep
sqlnr_comp
3.
sqlnq_qtb::insert_between
sqlnq_qun::insert_selbox
sqlnr_insert_selbox
sqlnr_optprep
sqlnr_optprep_action |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade the DB2 server to V9.7 Fix Pack 8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This problem has first been fixed in V9.7 Fix Pack 8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC89714
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2012
29.04.2013
29.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
