DB2 - Problem description
Problem IT36572 | Status: Closed |
FEDERATED QUERY MULTIBYTES CHARACTERS RETURNING '001A' USING THEODBC WRAPPER | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
The steps to reproduce the issue is as below: -- create ODBC server create server SERVER1 type oracle_odbc version 6.0 OPTIONS(host 'maury1.fyre.ibm.com', port '1521', service_name 'orclpdb.fyre.ibm.com', CODEPAGE '1208', password 'Y', pushdown 'Y', DB2_IUD_ENABLE 'Y'); create user mapping for user server SERVER1 options (REMOTE_AUTHID 'J15USER2', REMOTE_PASSWORD 'J15USER2'); -- insert multibytes characters set passthru server1; create table Tes1(a nchar(10)); insert into Tes1 values( '??'); set passthru reset; create nickname nk1 for SERVER1."J15USER2"."NCHARTAB"; -- returned unexpected result select hex(a) from nk1 1 ----------- 001A001A00200020002000200020002000200020 1 record(s) selected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * RETURNING '001A' USING THE * * ODBC WRAPPER * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V11.5.6 * **************************************************************** | |
Local Fix: | |
Change the odbcinst.ini(odbc.ini) with 'IANAAppCodePage=106'. For example: [ODBC] InstallDir=/home/liuyaq/sqllib/federation/odbc IANAAppCodePage=106 | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * RETURNING '001A' USING THE * * ODBC WRAPPER * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V11.5.6 * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.04.2021 16.06.2021 26.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |