By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Import Dump file.

P: 2

I am new in DB2.
In DB2 dump file of export option is OS dependent. I want to export a data from windows machine to linux machine using export/import option. Can anyone help me please?

Oct 25 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 297

IBM offers the IXF format which is understood by DB2 installations on all Linux, Unix and Window$ systems. (DB2 on z/OS doesn't, and about DB2 on i5/OS I don't know.)

Expand|Select|Wrap|Line Numbers
  1. db2 export to c:\temp\dump.ixf select a,b,c from my.table
  3. db2 (import, load) from /tmp/dump.ixf (insert, replace) into my.table
Regards, Bernd
Oct 25 '07 #2

Post your reply

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