By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,018 Members | 930 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,018 IT Pros & Developers. It's quick & easy.

Importing V8.2 IXF files into V5.2

P: n/a
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.


Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
I believe someone out there would have faced this similar problem.
Help anyone ??


Nov 12 '05 #2

P: n/a
ra***** 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

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

Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #3

P: n/a
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


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.