DB2 - Problembeschreibung
Problem IT26936 | Status: Geschlossen |
[COE_TIM]DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING AGGREGATE DISTINCT ON COLUMNIZED TABLES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
Db2 might abend when running a query with the following characteristics: 1. the query references column organized tables; 2. the query has at least one of these 5 aggregations: MAX, MIN, COUNT, COUNT_BIG, SUM; 3. the aggregation(s) contain a aggregate distinct on a simple column, such as COUNT(distinct col) 4. the distinct operation can potentially cause sort heap spilling -----Frame------ ------Address----- ------Function + Offset------ 0x0000101DC13E4890 0x000010000CD664D8 _Z20sqlnd_inlineview_pdaR17sqlnq_qunElemListS0_P19sqlnd_Context_ StackiRi + 0x3d78 ( = offset 0xCA364D8 in /home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101DC13E5540 0x000010000CD662D0 _Z20sqlnd_inlineview_pdaR17sqlnq_qunElemListS0_P19sqlnd_Context_ StackiRi + 0x3b70 ( = offset 0xCA362D0 in /home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101DC13E61F0 0x000010000CD662D0 _Z20sqlnd_inlineview_pdaR17sqlnq_qunElemListS0_P19sqlnd_Context_ StackiRi + 0x3b70 ( = offset 0xCA362D0 in /home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101DC13E6EA0 0x000010000CD662D0 _Z20sqlnd_inlineview_pdaR17sqlnq_qunElemListS0_P19sqlnd_Context_ StackiRi + 0x3b70 ( = offset 0xCA362D0 in /home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101DC13E7B50 0x000010000CD53C64 _Z16sqlnd_qunset_pdaR17sqlnq_qunElemListRiRP9sqlnq_sati + 0x08f4 ( = offset 0xCA23C64 in /home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101DC13E7D40 0x000010000CD52148 _Z13sqlnd_opr_pdaRP9sqlnq_oprRiRP9sqlnq_sati + 0x00f8 ( = offset 0xCA22148 in /home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101DC13E7ED0 0x000010000CDD4CC0 _Z22sqlnd_insert_sel_aboveP9sqlnq_qtbRS0_P9sqlnq_qun + 0x0230 ( = offset 0xCAA4CC0 in /home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101DC13E7FD0 0x000010000E0EC99C _Z17sqlnr_egad_actionP10sqlnr_qrwaPiP14sqlnr_progress + 0x008c | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local-Fix: | |
db2set DB2_REDUCED_OPTIMIZATION=NO_EGAD, then restart Db2 | |
Lösung | |
Workaround | |
/* */ db2set -im DB2_REDUCED_OPTIMIZATION=NO_EGAD | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.11.2018 16.01.2020 16.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |