DB2 - Problem description
Problem IC86622 | Status: Closed |
RETURN NO DATA WHEN "VARGRAPHIC(A0."C1")" IS PUSHED DOWN TO AS400 DATASOURCE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
When using DRDA to connect to AS400 with VARGRAPHIC column type, you may get no data returned. Here is the reproduce steps: db2 create db fdb1 using codeset UTF-8 territory US COLLATE USING IDENTITY db2 catalog tcpip node inode remote ***.***.***.*** server 446 db2 catalog database *** as idb at node inode CREATE WRAPPER "DRDA" CREATE SERVER "***" TYPE DB2/ISERIES VERSION '6.1' WRAPPER "DRDA" AUTHORIZATION "***" PASSWORD "***" OPTIONS(COLLATING_SEQUENCE 'Y',DB2_MAXIMAL_PUSHDOWN 'Y',DBNAME 'idb',PUSHDOWN 'Y') CREATE USER MAPPING FOR *** SERVER "***" OPTIONS (REMOTE_AUTHID '***',REMOTE_PASSWORD '***') create table test1(c1 VARGRAPHIC(10)) insert into test1 values('12345') create table test2(c1 varchar(10)) insert into test2 values('12345') db2 => select * from test1 join test2 on test1.c1=test2.c1 C1 C1 -------------------- ---------- 12345 12345 db2 => select * from test1 join test2 on test2.c1=test1.c1 C1 C1 -------------------- ---------- 12345 12345 1 record(s) selected. set passthru *** create table testi(c1 varchar(10)) insert into testi values('12345') create table test1(c1 VARGRAPHIC(10)) insert into test1 values(VARGRAPHIC('12345')) set passthru reset create nickname testn for ***.***.testi create nickname testn1 for ***.***.test1 db2 => select * from test1 join testn on testn.c1=test1.c1 C1 C1 -------------------- ---------- 12345 12345 1 record(s) selected. db2 => select * from test1 join testn on test1.c1=testn.c1 C1 C1 -------------------- ---------- 0 record(s) selected. | |
Problem Summary: | |
User affected: Users who use DRDA wrapper of in InfoSphere Federation Server Problem description and summay: See error description | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Problem was fistly fixed in Version 10, FixPak 2. This fix should be applied on the federation Server. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.09.2012 04.01.2013 04.01.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.2 | |
10.5.0.2 |