DB2 - Problem description
Problem IT40315 | Status: Closed |
DB2 MAY TRAPP IN DFPAL_DECIMAL128FROMSTRING | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
There is a potential flaw in the code that relates to the handling of the initialization of one context structure in DFPAL library which used to perform the decimal/float arithmetic. Due to this issue, Db2 may trap under timing condition when Db2 has to convert a string into a decimal value during the execution or compiling of a statement. The trap stack has the following top lines: dfpal_decimal128FromString__FPCc + 0x298 OSSDecimal128FromString__FCPCc + 0x18 sqlvpdc2dfp + 0x174 e.g. An statement which contains a predicate similar to the following may hit this issue: 1) A_DECIMAL_COLUMN '0' 2) TRIM(LENGTH(COLUMN1)) Note: Above are just 2 examples, in fact, any statement that have to convert a string into a decimal value, may hit this issue. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * When Db2 has to convert a string into a decimal value during * * the execution or compiling of a statement. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * The issue will be fixed on next release of Db2 for LUW. * **************************************************************** | |
Local Fix: | |
Rewrite the SQL statement to remove the part which may request Db2 converting a string into a decimal value. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * When Db2 has to convert a string into a decimal value during * * the execution or compiling of a statement. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * The issue will be fixed on next release of Db2 for LUW. * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.03.2022 21.04.2022 21.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |