467,923 Members | 1,766 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

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
Sep 4 '07 #1
  • viewed: 9860
Share:
2 Replies
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.tablename
Sep 11 '07 #2
docdiesel
Expert 100+
Hi,

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

Expand|Select|Wrap|Line Numbers
  1. db2move mydb import
  2.  
or
Expand|Select|Wrap|Line Numbers
  1.  
  2. db2move mydb load
  3.  
while in the directory with db2move.lst and the ixf files.

Regards, Bernd
Sep 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by TD Matthews | last post: by
2 posts views Thread by erkki | last post: by
4 posts views Thread by Christos Kalantzis | last post: by
2 posts views Thread by ibm_97 | last post: by
2 posts views Thread by Alan | last post: by
2 posts views Thread by Mani | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.