|
Problem IT26936
|
Status: Closed |
[COE_TIM]DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING AGGREGATE DISTINCT ON COLUMNIZED TABLES
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| Solution |
|
| Workaround |
/*
*/
db2set -im DB2_REDUCED_OPTIMIZATION=NO_EGAD |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.11.2018
16.01.2020
16.01.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
