DB2 FOR LUW / DB2FORLUW / A50 - DB2

SYSPROC.ADMIN_MOVE_TABLE returns SQL1224N for tables with 
self-referencing referential constraints, if parameter <tabname> 
was specified with trailing blank. 
 
This can also result in a Signal #11 (SIGSEGV): in 
stringArrayAppend(), the stack will look something similar to 
the following: 
 
-------Frame------ ------Function + Offset------ 
0x09000000484ABB98 stringArrayAppend__3OtmFPPcPiiPCcP5sqlca + 
0x338 
0x090000004852E7A4 getRefTables__3OtmFPCcT1PPcN53PiT9P5sqlca + 
0x22C4 
0x090000004858F4A8 swapOffline__3OtmFbT1P5sqlca + 0x3AA8 
0x0900000048591290 swap__3OtmFP5sqlca + 0xDB0 
0x090000004859C8A0 
admin_move_table__FPCcN91N21PsN913_N213_P13sqludf_dbinfoP5sqlcaP 
FUiPPv_ibT28_ + 0x20E0 
0x09000000485A2354 admin_move_table_int1 + 0x114 
 
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')"

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 7 or Later.                 * 
****************************************************************

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')"

First Fixed in DB2 LUW v10.5 Fixpack 7.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

05.03.2015
19.01.2016
27.04.2016