DB2 FOR LUW / DB2FORLUW / B10 - DB2

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.

****************************************************************
* 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.      *
****************************************************************

Rewrite the SQL statement to remove the part which may request
Db2 converting a string into a decimal value.

****************************************************************
* 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.      *
****************************************************************

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.03.2022
21.04.2022
21.04.2022