Hi,
I have a DB2 8.1.5 DB where I loaded data from Oracle using MTK.
I want to export the data and load them back..(I inherited the script and responsible for maintaining from now on)..

Here is the syntax I am using for importing data back into empty schema.
-------------
db2move agile import -io insert -u db2admin -p agile
db2 import from tab8.ixf of ixf lobs from D:\Agile9DB2Tmp\ modified by lobsinfile insert into ADMIN_HISTORY_DETAILS
-----------------------------
db2move to load the regular data and db2 import to load LOB related tables.

When I looked at the existing scripts, DB2 export is exporting the lob related tables as
tab01.ixf, tab01.msg, tab1a.001 while for regular tables, it is exporting as tab02.ixf, tab02.msg only. What will be the export command that does that?
Thanks.

EXPORT TO xxx.ixf LOBS TO /directory/where/lobs/go LOBFILE tab1a modified by lobsinfile select...