DB2 - Problem description
Problem IT34311 | Status: Closed |
Query with alias for complex column used in group by clause traps and generates FODC | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
FODC with stack similar to: x0000101B30FDCC80 0x000010000834D020 _Z20sqlng_build_COLD_objP9sqlng_blkP9sqlno_qtbP9sqlnq_qtbP17sqln o_order_classjP13sqlng_columnshPP10SQLD_FIELDPb + 0x0920 ( = offset 0x80AD020 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101B30FDCE20 0x000010000845121C _Z22sqlng_build_rev_TQB_opP9sqlng_blkP19sqlno_plan_operator + 0x01bc ( = offset 0x81B121C in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101B30FDCF40 0x00001000084537CC _Z19sqlng_process_tq_opP9sqlng_blkP19sqlno_plan_operator + 0x082c ( = offset 0x81B37CC in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101B30FDD070 0x00001000083348E4 _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0x00d4 ( = offset 0x80948E4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101B30FDD0F0 0x00001000083BC4F0 _Z21sqlng_process_sort_opP9sqlng_blkP19sqlno_plan_operator + 0x0310 ( = offset 0x811C4F0 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101B30FDD690 0x00001000083348E4 _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0x00d4 ( = offset 0x80948E4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101B30FDD710 0x000010000831E62C _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrlP9sqlnq_qun + 0x1a0c ( = offset 0x807E62C in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000101B30FDD8D0 0x00001000083B1FC4 _Z24sqlng_scan_derived_tableP9sqlng_blkP19sqlno_plan_operatorhP9 sqlnq_qun + 0x03d4 ( = offset 0x8111FC4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1 can affect certain queries: - NPS compatibility is enabled - query contains GROUP BY - alias is used for complex expression referencing the same column multiple times - mentioned alias is used in WHERE and GROUP BY clauses | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW USERS * **************************************************************** * PROBLEM DESCRIPTION: * * Failure as follows: * * SQL0901N The SQL statement or command failed because of * * a database system error. (Reason "Found zero CLOB.reset".) * * can affect certain queries: * * ? NPS compatibility is enabled * * ? query contains GROUP BY * * ? alias is used for complex expression referencing the same * * column multiple times * * ? mentioned alias is used in WHERE and GROUP BY clauses * **************************************************************** * RECOMMENDATION: * * Will be fixed in future fixpacks * **************************************************************** | |
Local Fix: | |
Local fix: Rewrite the query by replacing the alias in WHERE clause by complex expression | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW USERS * **************************************************************** * PROBLEM DESCRIPTION: * * Failure as follows: * * SQL0901N The SQL statement or command failed because of * * a database system error. (Reason "Found zero CLOB.reset".) * * can affect certain queries: * * ? NPS compatibility is enabled * * ? query contains GROUP BY * * ? alias is used for complex expression referencing the same * * column multiple times * * ? mentioned alias is used in WHERE and GROUP BY clauses * **************************************************************** * RECOMMENDATION: * * Will be fixed in future fixpacks * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.09.2020 09.04.2021 09.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |