DB2 FOR LUW / DB2FORLUW / 970 - DB2

UDF with string result types could be blocked from being pushed 
down 
 
UDF could be blocked from being pushed down under following 
conditions: 
1. local db is in ora compatible mode (e.g. db2set registry 
DB2_COMPATIBILITY_VECTOR set to ORA) 
2. remote server's server option varchar2_compat is set to N 
3. UDF has a result type of CHAR, VARCHAR, GRAPHIC, or 
VARGRAPHIC, e.g. select myfunc.mytrim(varchar_col) from 
nickname1

**************************************************************** 
* USERS AFFECTED:                                              * 
* all platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IFS v9.7.9.0                                      * 
****************************************************************

Setting the server option to Y

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
 

v97fp9, UDF will be pushed down and performance can be improved

Set server option  varchar2_compat to Y

Vorgänger  : APAR is sysrouted TO one or more of the following: IC93251 IC95397 
Nachfolger : 

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

07.05.2013
16.12.2013
16.12.2013

9.7.9.0,
9.7.FP9