how to import db2move.lst

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dushanthadee
    New Member
    • Sep 2007
    • 1

    how to import db2move.lst

    I have db2move.lst file add all table (.ixf) files.I need to know how to import those data using db2.
    Im new to db2.
    Plz can someone help me.
    dee
  • SAM689532
    New Member
    • Sep 2007
    • 2

    #2
    connect to the database with CLP command:
    connect to DBNAME user USERNAME
    After being connected,
    enter command :
    import from file.ixf of ixf messages msgfile.txt insert into schema.tablenam e

    Comment

    • docdiesel
      Recognized Expert Contributor
      • Aug 2007
      • 297

      #3
      Hi,

      I expect you exported them with db2move? All you have to do is import or load them again with the same command:

      Code:
      db2move mydb import
      or
      Code:
       
      db2move mydb load
      while in the directory with db2move.lst and the ixf files.

      Regards, Bernd

      Comment

      Working...