|
Problem IC74775
|
Status: Closed |
DB2 MAY ABEND WHILE COMPILING A QUERY WITH HASH PARTITIONED TABL E AND ALWAYS FALSE PREDICATE DUE TO PRESENCE OF ROLLUP OR CUBE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Db2 may abend under all the following conditions:
1. The table is hash partitioned
2. There is a ROLLUP or CUBE grouping.
3. There is a always false predicate. eg. 1<>1
The following stack trace is observed:
<StackTrace>
pthread_kill
sqloDumpEDU
sqldDumpContext
sqldDumpContext
sqlrr_dump_ffdc
sqlzeDumpFFDC
sqlzeSqlCode
sqlnn_erds
propagate_partitioning
local_select_box
local_box_analysis
pdb_box_analysis
pdb_graph_analysis
sqlnq_pdb_analysis
sqlnr_exe
sqlnr_exe
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlrr_prepare
sqljs_ddm_prpsqlstt
sqljsParseRdbAccessed
.sqljsParse.fdpr.clone.16
@64@sqljsSqlam
@64@sqljsDriveRequests
@64@sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqloEDUEntry + 0x260
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Db2 may abend under all the following conditions: *
* 1. The table is hash partitioned *
* 2. There is a ROLLUP or CUBE grouping. *
* 3. There is a always false predicate. eg. 1<>1 *
* *
* *
* The following stack trace is observed: *
* <StackTrace> *
* pthread_kill *
* sqloDumpEDU *
* sqldDumpContext *
* sqldDumpContext *
* sqlrr_dump_ffdc *
* sqlzeDumpFFDC *
* sqlzeSqlCode *
* sqlnn_erds *
* propagate_partitioning *
* local_select_box *
* local_box_analysis *
* pdb_box_analysis *
* pdb_graph_analysis *
* sqlnq_pdb_analysis *
* sqlnr_exe *
* sqlnr_exe *
* sqlnn_cmpl *
* sqlnn_cmpl *
* sqlra_compile_var *
* sqlra_find_var *
* sqlra_get_var *
* sqlrr_prepare *
* sqljs_ddm_prpsqlstt *
* sqljsParseRdbAccessed *
* .sqljsParse.fdpr.clone.16 *
* @64@sqljsSqlam *
* @64@sqljsDriveRequests *
* @64@sqljsDrdaAsInnerDriver *
* sqljsDrdaAsDriver *
* RunEDU *
* EDUDriver *
* sqloEDUEntry + 0x260 *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* Update to version 9.7 fixpack 5 or later fixpacks. *
**************************************************************** |
| Local Fix: |
Replace ROLLUP or CUBE with corresponding GROUPING SETS. For
example, GROUP BY ROLLUP(C1),ROLLUP(c2) can be rewritten as:
group by grouping sets ( (col1,col2),(col1),(col2),()); |
| available fix packs: |
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 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 is first fixed in version 9.7 fixpack 5. |
| Workaround |
Replace ROLLUP or CUBE with corresponding GROUPING SETS. For
example, GROUP BY ROLLUP(C1),ROLLUP(c2) can be rewritten as:
group by grouping sets ( (col1,col2),(col1),(col2),()); |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.03.2011
18.12.2011
18.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
