DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 UDB version 9.7 fixpack 7.                       * 
****************************************************************

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

Problem was first fixed in DB2 UDB V9.7 Fix Pack 7.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC88649 
follow-up : 

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

27.07.2012
30.10.2012
30.10.2012

9.7.FP7