DB2 - Problem description
Problem IT22011 | Status: Closed |
DB2 DOES NOT CAST THE JOIN COLUMNS CORRECTLY, LEADING TO A -901 ERROR IN CDE FOR DPF | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In the CDE hash join, the type and length must exactly match between the two joining keys. This is because the comparison is done in binary. In the following example, DB2 does not cast the join columns correctly, leading to a -901 error in CDE: create table coltab1 (ssn varchar(20)) organize by column; create table coltab2 (ssn decimal(9,0)) organize by column; db2 "SELECT base.ssn FROM coltab1 base INNER JOIN coltab2 mn ON TO_CHAR(base.ssn) = TO_CHAR(mn.ssn)" SSN -------------------- SQL0901N The SQL statement or command failed because of a database system error. (Reason "unexpected error at GetJoinPayloadEvaluator.cpp:136".) SQLSTATE=58004 This is related to APAR IT21361. This APAR covers the fix for DPF configurations. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Db2 Coulumn Organized on DPF users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, * * UNIX, and Windows or later * **************************************************************** | |
Local Fix: | |
Use CHAR function to set both sides of the comparison to the same number of characters. | |
available fix packs: | |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.08.2017 16.03.2018 16.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |