DB2 - Problem description
Problem IT37168 | Status: Closed |
DB2EXFMT TRAPS WHILE PROCESSING A QUERY CONTAINING HEXADECIMAL VALUES | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Special characters like ( and ) contained in the IN list of the optimized statement messed up the balanced brackets of the sql statement. This has affected how brackets are used for the stack and resulted in stack overflow. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.5 Fix Pack 7 * **************************************************************** | |
Local Fix: | |
Please execute db2exfmt command with '-f CY' option as below : $db2exfmt -d -1 -f CY -o Db2exfmt documentation https://www.ibm.com/docs/en/db2/11.5?topic=commands-db2exfmt-exp lain-table-format | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.5 Fix Pack 7 * **************************************************************** | |
Comment | |
First fixed in DB2 Version 11.5 Fix Pack 7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.06.2021 30.11.2021 30.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |