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 IC97640 Status: Geschlossen

FEDERATED QUERY MAY RECEIVE SQL0418N ERROR IF FEDERATED DATABASE SET
STMT_CONC=LITERALS

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Federated query failed with the following error when STMT_CONC 
is set to LITERALS: 
 
( 
   (select 'comset3' as SCHEMA ,'CSFRDCSPEC_HOLD_RULE_DC' as 
TBL_NAME , 
           DCSPEC_ID,DCITEM_NAME 
   from comset3.CSFRDCSPEC_HOLD_RULE_DC) except 
   (select 'comset3' as SCHEMA ,'CSFRDCSPEC_HOLD_RULE_DC' as 
TBL_NAME , 
           DCSPEC_ID,DCITEM_NAME 
   from comset4.CSFRDCSPEC_HOLD_RULE_DC)) 
Union ( 
(select 'comset4' as SCHEMA ,'CSFRDCSPEC_HOLD_RULE_DC' as 
TBL_NAME ,DCSPEC_ID, 
        DCITEM_NAME 
from comset4.CSFRDCSPEC_HOLD_RULE_DC) except 
   (select 'comset4' as SCHEMA ,'CSFRDCSPEC_HOLD_RULE_DC' as 
TBL_NAME , 
           DCSPEC_ID,DCITEM_NAME 
   from comset3.CSFRDCSPEC_HOLD_RULE_DC)) 
 
SQL1822N  Unexpected error code "-418" received from data source 
"DB2SERVER". 
Associated text and tokens are " SQL0418N  A statement contains 
a use of an 
untyped par".  SQLSTATE=560BD 
 
 
From access plan, the parameter marker is used in select list of 
the remote statement: 
 
RMTQTXT : (Remote statement) 
            SELECT DISTINCT A0."DCSPEC_ID", A0."DCITEM_NAME", 
-1, :H0 , :H1  FROM "SIVIEW"."CSFRDCSPEC_HOLD_RULE_DC" A0 FOR 
READ ONLY
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use Federation Server v10.5                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Federation Server v10.5 fp4 or above              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
The problem is fixed in v10.5 fp4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.11.2013
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList