DB2 - Problem description
Problem IT36498 | Status: Closed |
DB2 MAY RETURN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When customer is trying to concatenate a non-string(numerics) with a string(varchar), DB2 will implicitly cast non-string to a string. Because the default string units are CODEUNITS32 and each character takes 4 bytes, DB2 need to fix the string length. A bug exists in this step; if the numeric is a column from a column-organized table one of the following errors may occur: SQL0901N Â The SQL statement or command failed because of a database system error. (Reason "unexpected error at MinMaxPartialEvaluator.cpp:98".) SQLSTATE=58004 or SQL0901N Â The SQL statement or command failed because of a database system error. (Reason "unexpected error at GetJoinPayloadEvaluator.cpp:167.") SQLSTATE=58004 An FODC_AppErr will be generated. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users of DB2 with Column-organized databases * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.5 Mod 6 * **************************************************************** | |
Local Fix: | |
Modify the query so that the non-string is explicitly CAST to a string by use of the CAST function. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All users of DB2 with Column-organized databases * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.5 Mod 6 * **************************************************************** | |
Comment | |
Problem fixed in DB2 11.5 Mod 6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.04.2021 21.06.2021 21.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |