db2move questions

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • ibm_97@yahoo.com

    #1

    db2move questions

    Hi,

    I'd like to move 2 tables' data from schema1 in db1 to schema2 in db2.
    There's no schema1 in db2. I use something like the following, but I
    end up getting tables under schema2 in db2. Any help? Thanks!

    $db2move db1 export -tn table1,table2 -sn schema1 -u db2inst1 -p
    db2inst1
    $db2move db2 import -u schema2 -p schema2

  • Visu

    #2
    Re: db2move questions


    Once you are done exporting, edit the file "db2move.ls t" to have the
    new schema name then import it

    db2move db2 import

    Comment

    • ibm_97@yahoo.com

      #3
      Re: db2move questions

      Right, Thanks a lot.

      Comment

      Working...