DB2 FOR LUW / DB2FORLUW / 970 - DB2

Binding null value to host variables may cause SQL0901N error 
with message "Unknown type id 140". 
 
The problem may happen when all of the following conditions are 
met: 
1. The database manager configuration parameter 'FEDERATED' is 
set to 'YES'. 
2. running a query on a nickname and host variable is used in 
where-clause 
3. host variable is bound with a null value in a scenario like 
the following: 
"colname=:hostvariable :ind" and the value of ind is negative 
(indicating the value being bound is null) 
4. the application is bound with REOPT ALWAYS options 
 
The problem is the above scenario will cause the federation 
compiler internally handle a query like: "where colname = NULL" 
which will trigger error from federation compiler.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Federation users.                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See the error description.                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v97fp1.                                           * 
****************************************************************

Any of the following workarounds can bypass the problem: 
1. Change predicate to something like " :vc :ind IS NOT NULL AND 
COLUMN1 IS NOT NULL AND COLUMN1 = :vc ". 
 
2. For applications using static embedded SQL, specify option 
"REOPT ONCE" or "REOPT NONE" instead of "REOPT ALWAYS" while 
binding the applications with the bind command. This can avoid 
compiler from compiling the query with specific host variable 
values, including NULL. 
 
3. Simply remove the host variable indicator, and handle the 
NULL case before execution of the query in the application code.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 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 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 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
 

This problem is first fixed in version 9.7 fixpack 1.

keiner bekannt / siehe Local-Fix

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

19.06.2009
15.12.2009
15.12.2009

9.7.FP1