home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT04611 Status: Geschlossen

THE SQL0901 ERROR OF "NO FTSLPD THROUGH GB/UNION DISTINCT" IS
WRONGLY RETURNED DURING FEDERATED SERVER STATEMENT COMPILATION

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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]
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description above.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version V10.1 Fix Pack 5.                     * 
****************************************************************
Local-Fix:
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');
Lösung
First fixed in Version V10.1 Fix Pack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.09.2014
23.10.2015
23.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList