Migrating data with db_migrate_iias command - examples

For the migration to be successful, the target table must already exist in the target database, or you must provide the flag -createTable. Note that the content of the source table is always appended to the target table.

• You can migrate the table TableX on source to table TableX on target by using -t option:

  db_migrate_iias -source bluadmin p4sswrd bludb
  			  -target 129.42.38.10 bluadmin diff1cu1t bludb
  			  -t TableX

• You can migrate a table and change its name on the target, such as TableSource migrated to TableTarget:

  db_migrate_iias -source bluadmin p4sswrd bludb
  			  -target 129.42.38.10 bluadmin diff1cu1t bludb
  			  -mv TableSource TableTarget

• You can also migrate multiple tables with different and equivalent names at once:

  db_migrate_iias -source bluadmin p4sswrd bludb
                -target 129.42.38.10 bluadmin diff1cu1t bludb
                -mv TableSource1 TableTarget1
                -mv TableSource2 TableTarget2
                -t TableX TableY TableZ

  Note: Tables called with the -t option have precedence over -mv tables, which causes the following migration order:

  TableX → TableX
  TableY → TableY
  TableZ → TableZ
  TableSource1 → TableTarget1
  TableSource2 → TableTarget2

When the migration is finished, the following status is presented:

[PROCESS] Unloading has finished successfully
[PROCESS] TableSource -> TableTarget time: 175.33396 (0:02:55)
[PROCESS] Total time: 175.969131947 (0:02:55)
[VERBOSE] Removing /scratch/home/bluadmin/com.ibm.migration.iias.LjCRP_/ ...