DB2 - Problembeschreibung
Problem IC74732 | Status: Geschlossen |
DB2 MAY ABEND WHILE COMPILING A QUERY WITH HASH PARTITIONED TABL E AND ALWAYS FALSE PREDICATE DUE TO PRESENCE OF ROLLUP OR CUBE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All. * **************************************************************** * PROBLEM DESCRIPTION: * * Abstract: * * DB2 MAY ABEND WHILE COMPILING A QUERY WITH HASH PARTITIONED * * TABLE AND ALWAYS FALSE PREDICATE DUE TO PRESENCE OF ROLLUP * * OR CUBE. * * * * * * 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> * * * * * * 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),()); * **************************************************************** * RECOMMENDATION: * * Update to db2 version 9.5 fixpack 8 or later fixpack. * **************************************************************** | |
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),()); | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
This problem is first fixed in db2 version 9.5 fixpack 8. | |
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),()); | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC74775 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.02.2011 30.06.2011 30.06.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP8 | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |