DB2 FOR LUW / DB2FORLUW / A10 - DB2

BIGINT type column cannot be pushdown when using 
+,-,*,/,=,>,<,>=,<=,<> predicate 
For example, 
On Informix : 
create table test_bigint (a int8, b integer, c char(3)) 
 
On DB2 : 
select * from test_bigint where a=999999 
 
Federated Substatement #1: 
Server: TEST_PRM  (INFORMIX 11) 
SQL Statement: 
 
     SELECT A0."a" , A0."b" , A0."c" 
     FROM "informix" ."test_bigint" A0 
     FOR READ ONLY 
 
Optimized Statement: 
------------------- 
SELECT Q1.A AS "A", Q1.B AS "B", Q1.C AS "C" 
FROM IIDEV25.NN_SALES AS Q1 
WHERE (Q1.A = 999999)

User affected: 
  Users who use  InfoSphere Federation Server 
Problem description and summay: 
  See error description

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
 

Problem was fistly fixed in Version 10.1, FixPak 3. This 
fix should be applied on the federation Server.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.09.2013
31.10.2013
31.10.2013