I am testing the Db2 Migration Service beta and I'm having a problem migrating tables that have separate tables spaces assigned for indexes and LOBs.
11:00:26.725 | DEBUG | <30939:MainThread> db_handler.py:358 | Final DDL: CREATE TABLE "TMWIN"."WEB_VENDOR_FIELDS" ("ACCESS_CODE" VARCHAR(15 OCTETS) NOT NULL , "FIELD_NAME" VARCHAR(30 OCTETS) NOT NULL , "TRUCKMATE_TABLE" VARCHAR(40 OCTETS) NOT NULL WITH DEFAULT 'TLORDER' , "DISPLAY_ORDER" INTEGER , "ROW_TIMESTAMP" TIMESTAMP NOT NULL GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP , "INS_TIMESTAMP" TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ) INDEX LONG ORGANIZE BY ROW;
10.91.0.65:50000 (TARGET): ('42601', '[42601] [IBM][CLI Driver][DB2/NT64] SQL0104N An unexpected token "INDEX LONG" was found following "CURRENT TIMESTAMP )". Expected tokens may include: "<space>". SQLSTATE=42601\n (-104) (SQLExecDirectW)')
Our current table definition is
CREATE TABLE WEB_VENDOR_FIELDS(
ACCESS_CODE VARCHAR(15) NOT NULL,
FIELD_NAME VARCHAR(30) NOT NULL,
TRUCKMATE_TABLE VARCHAR(40) NOT NULL DEFAULT 'TLORDER',
DISPLAY_ORDER INTEGER,
ROW_TIMESTAMP TIMESTAMP NOT NULL GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP ,
INS_TIMESTAMP TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP,
PRIMARY KEY(ACCESS_CODE, TRUCKMATE_TABLE, FIELD_NAME))
IN TMWIN_4K
INDEX IN TMWIN_4K_IDX
LONG IN TMWIN_4K_LOB
@
As you can see when it is creating the code for the new DDL, it isn't including the IN TBSPACENAME that is in the original DDL for the table. Do we know if there is work being done to fix this in the next beta?
------------------------------
Freddie Callander
------------------------------
#Db2