home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT07404 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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 Summary:
**************************************************************** 
* 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')"
Solution
First Fixed in DB2 LUW v10.1 Fixpack 5.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

28.02.2015
13.07.2015
13.07.2015
Problem solved at the following versions (IBM BugInfos)


Problem solved according to the fixlist(s) of the following version(s)


10.1.0.5

FixList