DB2 - Problem description
Problem IT34425 | Status: Closed |
HANGING QUERY IN CLOB TYPE STATEMENTS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Hanging query in case of a small but specific exceeding of the limit. e.g. select length(t.a) from table(test_clob(4 * 1024 * 1024 + 5)) t (a clob); Size of CLOB in DB2GENERAL java style. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * Hanging query in case of a small but specific exceeding of * * the * * limit. * * e.g. select length(t.a) from table(test_clob(4 * 1024 * 1024 * * + * * 5)) t (a clob); * * * * Size of CLOB in DB2GENERAL java style. * **************************************************************** * RECOMMENDATION: * * Upgrade to product version V11.1 m4 fp6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * Hanging query in case of a small but specific exceeding of * * the * * limit. * * e.g. select length(t.a) from table(test_clob(4 * 1024 * 1024 * * + * * 5)) t (a clob); * * * * Size of CLOB in DB2GENERAL java style. * **************************************************************** * RECOMMENDATION: * * Upgrade to product version V11.1 m4 fp6 * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.10.2020 31.03.2021 31.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |