Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 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 FixList
10.5.0.2 FixList