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
> 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