DB2 FOR LUW / DB2FORLUW / 970 - DB2

Statement:  select * from nick where c1 > ? 
where the remote column type of c1 is binary(24). The column 
comparison can not be pushdown. 
 
Federated Substatement #1: 
(    3) Server: SERVER1  (MSSQLSERVER 2000) 
        SQL Statement: 
 
             SELECT A0."C1" , A0."C2" 
             FROM "SCHEMA" ."T1" A0

**************************************************************** 
* USERS AFFECTED:                                              * 
* MSSQL binary column DOES NOT ALLOW PUSH DOWN IN PREDICATES   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Statement: delete from asn.ibmqrep_donemsg where recvq=?     * 
* andmqmsgid >=? and mqmsgid <=?.Here the remote column type   * 
* of mqmsgid is binary(24). Thecolumn comparison can not be    * 
* pushdown.                                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Infosphere federation v97fp3  or the afterversion * 
****************************************************************

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

In v97fp3 or the after version, MSSQL binary column will be 
 
allow to be pushdown in predicates by setting the column option 
binary_rep to be 'Y'.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.10.2009
31.05.2010
31.05.2010

9.7.FP3