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

Import Problem Urgent

P: n/a
hi, i have a problem in importing data from .ixf files the dump was got
from AIX box and this dump is to be imported to win2003 box with
db2v7.2 fixpack8. i have just created a new db in the win2003 and this
dump is to be imported to the new db. IS the db2look.sql necessary for
doing this???or is there any other method of doing this. kindly help me
in this issue.
thanks
lakshmanan

Mar 1 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
1.)If the database created in the Windows machine has the same DDl's as
the one in the AIX , then you need not worry.

Else, you need to create the DDL using db2look.

2.) Now the Dump will have data which is not readable and in IXF format

You need to use db2move to import the data.

db2move <database name> IMPORT -io INSERT

Mar 1 '06 #2

P: n/a
hi with the ref to your reply i would like to tell you that we do not
have the ddl in the windows box its is new and does not have any data
only the dump is to be imported. and it is in ixf format i tried
db2move <database name> IMPORT -io replace_create.

or is the ddl file necessary for the import action.

lakshmanan

Mar 1 '06 #3

P: n/a
"lakshmananl" <la************@gmail.com> wrote in message
news:11**********************@t39g2000cwt.googlegr oups.com...
hi with the ref to your reply i would like to tell you that we do not
have the ddl in the windows box its is new and does not have any data
only the dump is to be imported. and it is in ixf format i tried
db2move <database name> IMPORT -io replace_create.

or is the ddl file necessary for the import action.

lakshmanan


You should use db2look to get all the DDL, since the IXF file will only
create the table and primary key.
Mar 1 '06 #4

P: n/a
Hi lakshman,

You have said that "i have just created a new db in the win2003 and
this
dump is to be imported to the new db."
After creating the DB, you need to create the tables to hold the data
from the AIX box right.
Since you have to create an exact replica of the AIX box,for creating
tables and other keys you need to issue the db2look command at the AIX,
which will create a file say db2look.sql and you need to ftp it to the
windows machine or get hold of it some how.

Now, you need to run that script(db2look.sql) in the windows machine
which will create the DDL.

After that, you need to issue the db2move command which does the
import.

db2look -- > creates the necessary ddl
db2move --> Imports data.

Hope this helps!!

Mar 1 '06 #5

P: n/a
hi, this is actually a dump from the client side and they have not sent
the db2look.sql file in the dump so how can we proceed further is there
a way for doing the import using the .ixf files. Or can we ask them to
send the db2look.sql file.

lakshmanan

Mar 1 '06 #6

P: n/a
hi can you guide me with the syntax for creating the table with the ixf
file in the db.

lakshmanan

Mar 1 '06 #7

P: n/a
In article <11**********************@i39g2000cwa.googlegroups .com>,
lakshmananl (la************@gmail.com) says...
hi can you guide me with the syntax for creating the table with the ixf
file in the db.

lakshmanan


db2 import from <ixffile> of ixf create into <tablename>

Read the docs at http://tinyurl.com/jhh9z
Mar 1 '06 #8

P: n/a
Maybe just add a bit more to this
db2 import from <ixffile> of ixf create into <tablename> in <tbspacename>

By the way this import will create and populate the table, all user defined
indexes (not system created).
So if the unique index for a PK was created separately, it will be there but
not the PK definition.
alter <tablename> primary key .....

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gert van der Kooij" <ge**@invalid.nl> a écrit dans le message de news:
MP************************@news.xs4all.nl...
In article <11**********************@i39g2000cwa.googlegroups .com>,
lakshmananl (la************@gmail.com) says...
hi can you guide me with the syntax for creating the table with the ixf
file in the db.

lakshmanan


db2 import from <ixffile> of ixf create into <tablename>

Read the docs at http://tinyurl.com/jhh9z


Mar 1 '06 #9

P: n/a
lakshmananl wrote:
hi, i have a problem in importing data from .ixf files the dump was got
from AIX box and this dump is to be imported to win2003 box with
db2v7.2 fixpack8. i have just created a new db in the win2003 and this
dump is to be imported to the new db. IS the db2look.sql necessary for
doing this???or is there any other method of doing this. kindly help me
in this issue.


IXF files include the table definition (columns, data types, etc.) So you
can simply import the IXF file and tell DB2 in the import command that it
shall create the table. That's all.

Now, Version 7 is out of service for more than a year. So I would recommend
that you move to Version 8 or at least to the latest FixPak of V7.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Mar 3 '06 #10

P: n/a
hi, i thank you all for the guidance. and solved the problem thank you
once again.
thanks and regards
lakshman

Mar 10 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.