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

ERROR SQL0104N MAY HAPPEN WHEN CALLED ADMIN_MOVE_TABLE, IF THE TABLE HAD
COMMENT ON IT.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Error SQL0104N may happen when called ADMIN_MOVE_TABLE, if the 
table had comment on it and in the comment there are quotations 
in it. 
 
 
CALL 
 
SYSPROC.ADMIN_MOVE_TABLE('IPSSRV','IPS_EXCEPTION_TYPES','AMS2',' 
AMS2','A 
MS2','','','','','','MOVE') 
SQL0104N  An unexpected token "N''" was found following 
"SYSTEM_DECISION 
is 
'".  Expected tokens may include:  "<space>".  SQLSTATE=42601
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of admin_move_table                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW V10.1 FP1                                 * 
****************************************************************
Local-Fix:
remove the comment from the table will workaround the problem.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Problem fixed in DB2 LUW V10.1 FP1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.06.2012
15.11.2012
15.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList