How to import multiple tables in .ixf format to database?

[Gayathiry A]

Now i have tried with IMPORT FROM "E:\DOCS\JARS\t estDB-data\test.ixf" OF IXF CREATE INTO testDB.test;

Is there any way to import more than one .ixf files at once ? Could anybody help me on this ?

[vijay2082]

Hi,

I wonder what could be the need. If you need to import from a single IXF file then create a single IXF file from source. DB2 is smart enough to load data in a smart way for you. If there are multiple IXF files then it's a normal Db behaviour to get all ixf files loaded in serial order as data may not be appropriate from different sources. If at all all data extracted from source is as per the destination table specification and that you have no choice than to extract multiple times, then better extract it in del format from all sorces, make a one file and then load from this single file.

You can create a smart script to pickup up multiple ixf files and load in your db2 database. Choice is yours.

Have you ever tried cursore load new feature, egere you can directly load data into a remote db2 database ?

Cheers, Vijay

[pramodds]

Hi,

try this in this format, it could work.

IMPORT from /appldata/dwins25p/cryr3_1/DART0002/TS1116T2.IXF,
/appldata/dwins25p/cryr3_1/DART0003/TS1116T2.IXF,
/appldata/dwins25p/cryr3_1/DART0004/TS1116T2.IXF,
/appldata/dwins25p/cryr3_1/DART0005/TS1116T2.IXF
of IXF Method P (1,2,3,4,5,6,7, 8,9,10) messages ....and so on.

We usually give multiple Input files for load or import for partitioned environment. I have not tried that in ESE setup and but u can give and try and let me know if it works.

Cheers
Pramod