DB2 FOR LUW / DB2FORLUW / A10 - DB2

If there are federated server nicknames involved in the 
statement, and there are function used for the header 
expression, and groupby  or union in the statement, the error 
could happen. 
 
Possible entry in db2diag.log: 
 
 
2014-05-14-24.42.14.436790-240 E128482E1881          LEVEL: Info 
(Origin) 
PID     : 21123                TID : 46912984049984  PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
TESTDB 
APPHDL  : 0-85                 APPID: *N0.db2inst1.140911024510 
AUTHID  : db2inst1             HOSTNAME: host1 
EDUID   : 50                   EDUNAME: db2agent (TESTDB) 0 
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 
MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS 
          "unexpected error but state is OK" 
DATA #1 : String, 62 bytes 
An unexpected error was detected during statement compilation. 
DATA #2 : Boolean, 1 bytes 
true 
DATA #3 : Boolean, 1 bytes 
false 
DATA #4 : Boolean, 1 bytes 
false 
DATA #5 : Boolean, 1 bytes 
false 
DATA #6 : Hex integer, 4 bytes 
0x00000000 
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 35 
 sqlerrmc: No ftslpd through GB/UNION DISTINCT 
 sqlerrp : SQLNR271 
 sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFFFB      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
DATA #8 : Hex integer, 4 bytes 
0x00000040 
DATA #9 : String with size, 266 bytes 
SELECT s.DEVREVSTEP, REPLACE(:L0 , :L1 , :L2 ), 
ROUND(a_pg$iso.calculate_iso(SUM(r.ROLLUP_VALUE), s.DEVREVSTEP), 
:L3 ) FROM   A_TESTING_SESSION s LEFT JOIN 
A_TESTING_SESSION_ROLLUP r ON r.LAO_START_WW = s.LAO_START_WW 
WHERE  s.VALID_FLAG 
DATA #10: String, 245 bytes 
Compiler error stack for rc = -2144272209: 
sqlnn_cmpl[370] 
sqlnr_exe[1200] 
sqlnr_rcc[100] 
sqlnr_seq[100] 
sqlnr_comp[110] 
sqlnr_optprep_action[100] 
sqlnr_optprep_chunk3[2163] 
sqlnr_ftslpd[500] 
sqlnr_ftslpd_action[1000] 
sqlnr_ftslpd_thr_pdpath[5]

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description above.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version V10.1 Fix Pack 5.                     * 
****************************************************************

Disable the pushdown using ALTER SERVER command, but it may 
impact performance. 
 
ie) alter server "SERVER1" type sybase version 12.5 wrapper 
"WRAPPER1" authorization "user1" password "xxxx" options (node 
'ABC', dbname 'SAMPLE', password 'Y',  pushdown 'Y');

First fixed in Version V10.1 Fix Pack 5.

not known / see Local fix

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

25.09.2014
23.10.2015
23.10.2015