Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in DB2 only
Search
Advanced Search
Forums
Product Launch
Updates
Today's Posts
Member List
Calendar
Home
Forum
Topic
DB2
how to import db2move.lst
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
dushanthadee
New Member
Join Date:
Sep 2007
Posts:
1
#1
how to import db2move.lst
Sep 4 '07, 08:35 AM
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
Join Date:
Sep 2007
Posts:
2
#2
Sep 11 '07, 07:49 AM
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
Post
Cancel
docdiesel
Recognized Expert
Contributor
Join Date:
Aug 2007
Posts:
297
#3
Sep 11 '07, 05:35 PM
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
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment