DB2 FOR LUW / DB2FORLUW / A10 - DB2

select statement with to_date may trap in federated environment. 
 
A column which is specified date or timestamp. 
 
For example) 
date case 
db2 "describe table ndate" 
 
                                Data type 
Column 
Column name                     schema    Data type name 
Length     Scale Nulls 
------------------------------- --------- ------------------- 
---------- ----- ------ 
D1                              SYSIBM    DATE 
4     0 Yes 
 
timestamp case 
=> db2 "describe table nts" 
                                Data type 
Column 
Column name                     schema    Data type name 
Length     Scale Nulls 
------------------------------- --------- ------------------- 
---------- ----- ------ 
D2                              SYSIBM    TIMESTAMP 
10     6 Yes 
 
Both of the following SQL may trap. 
select * from ndate 
  where to_date(d1,'yyyy-mm-dd') ='2011-11-11' 
select * from nts 
  where to_date(d2,'yyyy-mm-dd') ='2011-11-11' 
 
Here is a snippet of stack trace. 
 
<sqlnq_qclqncparent::op> 
<sqlnt_translate::sqlnt_add_function> 
<sqlnt_translate::sqlnt_add_expression> 
<sqlnt_translate::sqlnt_add_function> 
<sqlnt_translate::sqlnt_add_expression> 
<sqlnt_translate::sqlnt_add_predicates> 
<sqlnt_translate::sqlnt_translate_scan> 
<sqlnt_translate::dispatch_pop> 
<sqlnt_translate::sqlnt_translate_sort> 
<sqlnt_translate::dispatch_pop> 
<sqlnt_translate::sqlnt_translate_scan> 
<sqlnt_translate::dispatch_pop> 
<sqlnt_translate::sqlnt_translate_mate> 
<sqlnt_translate::dispatch_pop> 
<sqlnt_translate::sqlnt_translate_pipe> 
<sqlnt_translate::dispatch_pop> 
<sqlnt_translate::sqlnt_translate_ship>

**************************************************************** 
* USERS AFFECTED:                                              * 
* FEDERATED ENVIRONMENT                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 10.1 fixpack 2.                   * 
****************************************************************

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
 

Problem was first fixed in DB2 UDB Version 10.1 Fix Pack 2.

not known / see Local fix

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

28.11.2012
31.12.2012
31.12.2012