\n1) Setup the database\n\n    destroydb data_warehouse\n    createdb data_warehouse\n    extenddb -lii_dbloc1 . . .\n    extenddb -lii_dbloc2 . . .\n    extenddb -lii_dbloc3 . . .\n    extenddb -lii_dbloc4 . . .\n    extenddb -lii_dbloc5 . . .\n    extenddb -lii_dbloc6 . . .\n    extenddb -lii_dbloc7 . . .\n    extenddb -lii_dbloc8 . . .\n    extenddb -lii_dbloc9 . . .\n    extenddb -lii_dbloc10 . . .\n    extenddb -lii_dbloc11 . . .\n    extenddb -lii_work2 . . .\n    ckpdb data_warehouse\n\n2) Run infodb and verify all alternate locations are shown for both Ingres and vectorwise.\n\n3) Make sure all directories exist.\n\n4) Check the content of /...//vectorwise/data_warehouse/wal/location_map and verify it has all the locations listed as the file is in your source system.\n\n5) Connect to the database using sql data_warehouse and create/drop a dummy X100 table to make sure the X100 / Vectorwise server starts successfully. Note, this is because, as of vectorwise.log, it appears that since 2020-11-26 no X100 / Vectorwise server was ever successfully started for any database.\n\n    sql data_warehouse\n    * commit\\p\\g\n    * create table dummy as select * from iitables with structure=x100\\p\\g \n\n6) Copy the required files from source (as per the KB doc Cloning Vector / Ingres Database Using Rollforwarddb) to the target.\n\n7) Run rollforwarddb as you have done before\n