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

ALTER NICKNAME GENERATED BY DB2LOOK CAUSED SQL0104N AN UNEXPECTED TOKEN
")" WAS FOUND

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
db2look can be used to generate DDLs for nicknames. However the 
generated SQLs may cause DB21034E 
once executed. 
 
The following is an example. 
 
$ db2look -d db1 -e -fedonly 
 
The output has the following: 
 
ALTER NICKNAME "DB2INST1"."DRDATX1"   ADD CONSTRAINT FKC1 
FOREIGN KEY(C1) REFERENCES "DB2INST1"."DRDATX2" (C1)  NOT 
ENFORCED ENABLE QUERY OPTIMIZATION  ADD CONSTRAINT FKC2 FOREIGN 
KEY(C2) REFERENCES "DB2INST1"."DRDATX2" (C1)  NOT 
ENFORCED ENABLE QUERY OPTIMIZATION) NOT ENFORCED ENABLE QUERY 
OPTIMIZATION; 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
 
valid Command Line Processor command.  During SQL processing it 
returned: 
 
SQL0104N  An unexpected token ")" was found following "E QUERY 
OPTIMIZATION". 
 
Expected tokens may include:  "<space>".  SQLSTATE=42601
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 8                        * 
****************************************************************
Local-Fix:
Remove ") NOT ENFORCED ENABLE QUERY OPTIMIZATION" from the 
generated "ALTER NICKNAME" SQLs
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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

Lösung
Fixed in Version 9.7 Fix Pack 8
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.08.2012
02.04.2013
02.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList