Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2006

Tip: Looking for answers? Try searching our database.

Import Problem Urgent

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lakshmananl - 01 Mar 2006 03:54 GMT
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
rAinDeEr - 01 Mar 2006 04:16 GMT
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
lakshmananl - 01 Mar 2006 05:32 GMT
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
Mark A - 01 Mar 2006 05:34 GMT
> 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
[quoted text clipped - 4 lines]
>
> lakshmanan

You should use db2look to get all the DDL, since the IXF file will only
create the table and primary key.
rAinDeEr - 01 Mar 2006 05:44 GMT
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!!
lakshmananl - 01 Mar 2006 05:55 GMT
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
lakshmananl - 01 Mar 2006 05:57 GMT
hi can you guide me with the syntax for creating the table with the ixf
file in the db.

lakshmanan
Gert van der Kooij - 01 Mar 2006 08:21 GMT
> 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
Pierre Saint-Jacques - 01 Mar 2006 20:44 GMT
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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>> hi can you guide me with the syntax for creating the table with the ixf
>> file in the db.
[quoted text clipped - 4 lines]
>
> Read the docs at http://tinyurl.com/jhh9z 
Knut Stolze - 03 Mar 2006 07:36 GMT
> 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.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

lakshmananl - 10 Mar 2006 04:17 GMT
hi, i thank you all for the guidance. and solved the problem thank you
once again.
thanks and regards
lakshman
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.