Importing V8.2 IXF files into V5.2

Hi All,

As a regression step, I want to import the data (exported from the v8.2
client IXF format) into the v5.2 format. The source database server is
on a OS/400 v5r2 ( was not able to find out the version of DB2 on
AS/400 as eveyone seems to think its the same version number as the
operating system, which is v5.2). The destination database server is on
an RS/6000 UNIX box which has a version of 2.1.2 and use the v5.2 CAE
to import the exported data of the AS/400. But the DB2 v5.2 doesn't
understand IXF header version which i believe is in the same format.

For the rollout, the IXF generated by the DB2 v5.2 worked perfectly on
the v8.2. If a new IXF format is used in V8.2, I would also expect an
option to export it in the previous version format, just to be
compatible. Any help is appreciated, if you know how to import data in
the v8.2 to v5.2 format.

Cheers,
Raf.

I believe someone out there would have faced this similar problem.
Help anyone ??

Thanks.

rafeekb@techie.com wrote:

> I believe someone out there would have faced this similar problem.
> Help anyone ??

Are you seriously asking if you could export data from DB2 UDB V8 and import
it into DB2 UDB V5? Version 5 is years old and Version 7 is out of service
already...

I'd say your best bet is to stick to CSV files.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Thanks Knut for the reply.
Yes, we are sad...:-) its only as a backup step if things dont go
according to plan. The problem I am facing is with the format of IXF
files generated from the DB2 v8.2 which I beleive is in IXF ver2 and
trying to import it back to DB2 v5.2 which I understand is in IXF ver1
format.

Cheers,
Raf.