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

SYSPROC.ADMIN_MOVE_TABLE RETURNS SQL1224N FOR TABLES WITH SELF-REFERENCING
REFERENTIAL CONSTRAINTS

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
SYSPROC.ADMIN_MOVE_TABLE returns SQL1224N for tables with 
self-referencing referential constraints, if parameter <tabname> 
was specified with trailing blank. 
 
Repro is: 
 
db2 "CREATE TABLE DB2INST1.MYTAB  ( 
    WSID INTEGER NOT NULL PRIMARY KEY, 
    BASEWSID INTEGER WITH DEFAULT NULL )" 
 
db2 "ALTER TABLE DB2INST1.MYTAB 
 ADD CONSTRAINT SQL131024112702400 FOREIGN KEY 
  (BASEWSID) 
 REFERENCES DB2INST1.MYTAB 
  (WSID) 
 ON DELETE RESTRICT 
 ON UPDATE NO ACTION 
 ENFORCED 
 ENABLE QUERY OPTIMIZATION" 
 
db2 "call SYSPROC.ADMIN_MOVE_TABLE('DB2INST1','MYTAB 
','','','','','','','','','MOVE')"
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.1 Fixpack 5 or Later.                 * 
****************************************************************
Local-Fix:
Cancel the failed ADMIN_MOVE_TABLE and run again without the 
trailingspace: 
 
db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('DB2INST1','MYTAB 
','TS_ICMSFQ04_D','TS_ICMSFQ04_I','TS_ICMSFQ04_L','','','','','' 
,'CANCEL')" 
db2 "CALL 
SYSPROC.ADMIN_MOVE_TABLE('DB2INST1','MYTAB','TS_ICMSFQ04_D','TS_ 
ICMSFQ04_I','TS_ICMSFQ04_L','','','','','','MOVE')"
Lösung
First Fixed in DB2 LUW v10.1 Fixpack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
28.02.2015
13.07.2015
13.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList