Db2

 View Only
  • 1.  Db2 Migration Service beta

    Posted Mon July 18, 2022 09:20 AM
    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


  • 2.  RE: Db2 Migration Service beta

    Posted Tue July 19, 2022 11:38 AM
    I found my mistake.  I had missed the --preserve-tablespaces option parameter in the documentation.

    ------------------------------
    Freddie Callander
    ------------------------------