DB2 FOR LUW / DB2FORLUW / A10 - DB2

You may receive SQL0901N error when using COUNT_BIG function 
with a teradata nickname including huge number of rows. 
 
Here is the reproducing SQLs: 
 
CREATE NICKNAME N1 FOR 
TERASERV."teradata_schema".?teradata_table? 
 
CREATE FUNCTION DB2INST1.COUNT(SYSIBM.CHAR()) RETURNS BIGINT 
SOURCE SYSIBM.COUNT_BIG(SYSIBM.CHAR()) 
 
CREATE FUNCTION MAPPING MY_FUN FOR 
SYSIBM.COUNT_BIG(SYSIBM.CHAR()) SERVER TERASERV OPTIONS 
(REMOTE_NAME 'COUNT(:1P)') 
 
SET CURRENT PATH DB2INST1, SYSTEM PATH 
 
select count(distinct "C2"), case when max("C2") is null then '' 
else varchar(rtrim(char(max("C2"))),33) end from N1 
1                    2 
-------------------- --------------------------------- 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "Unknown Type".)  SQLSTATE=58004

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

not known / see Local fix

Support nnstat to handle DECFLOAT in this APAR

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

01.12.2013
02.06.2014
02.06.2014