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

URGENT:Exporting and Importing data using IXF format

P: n/a
Hello All,

Is there any way to export data in the IXF version 1 format from a DB2
v8.2 database ?

The problem I am facing is to get the data from a v8.2 database which
produces a version 2 IXF and import it on to a v5.2 database which
knows only about version 1 IXF format.

Any suggestions, help is much appreciated.

Regards.

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


P: n/a
<ra*****@techie.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hello All,

Is there any way to export data in the IXF version 1 format from a DB2
v8.2 database ?

The problem I am facing is to get the data from a v8.2 database which
produces a version 2 IXF and import it on to a v5.2 database which
knows only about version 1 IXF format.

Any suggestions, help is much appreciated.

Regards.

Use a format other than IXF. Is there a legitimate reason why you must use
IXF format? Get the DDL separately with db2look command.
Nov 12 '05 #2

P: n/a
The source data is coming from an AS/400 machine and going to a UNIX
box and the reason for using IXF format is to take care of the EBCDIC
to ASCII convertions. I believe IXF is mainly used for transferring
data across platforms. Its the format thats causing the problem.

Cheers.

Nov 12 '05 #3

P: n/a
Hello,

the codepage conversion between DB2 databases on different platforms has
*nothing* to do with export/import formats! DB2 already presents the data
to the export utility converted to the codepage applicable for the platform
where it is running.

Only thing I know about is, that export and import are restricted to
IXF-format when running them against remote DB2 databases on AS/400 or z/OS
(f.k.a. OS/390).

But perhaps this trick may help you: export your AS/400 data in IXF-format,
create a "transfer" database in your DB2 V8.2 and import the IXF-files there
(they inherit the table definition as well, if you used the proper
parms...). Afterwards, export the data again from the "transfer" tables, but
this time in DEL-format (for example). This DEL-export files can then be
imported to your V5.2 database on UNIX.

Cheers - Walter.

<ra*****@techie.com> schrieb im Newsbeitrag
news:11**********************@z14g2000cwz.googlegr oups.com...
The source data is coming from an AS/400 machine and going to a UNIX
box and the reason for using IXF format is to take care of the EBCDIC
to ASCII convertions. I believe IXF is mainly used for transferring
data across platforms. Its the format thats causing the problem.

Cheers.

Nov 12 '05 #4

P: n/a
I don't think so.
If your problem is to use the IXF to create the table in 5.2 db then:
1) Use db2look on V8 to extract the ddl
2) Edit the output file to bring it to the 5.2 reqts.(db name, target
tblspc, etc..)
3) Export your data in filetype of DEL
4) Run the db2look output on V5.2
5) Import ... of DEL in your newly created table.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ra*****@techie.com> a écrit dans le message de news:
11*********************@g47g2000cwa.googlegroups.c om...
Hello All,

Is there any way to export data in the IXF version 1 format from a DB2
v8.2 database ?

The problem I am facing is to get the data from a v8.2 database which
produces a version 2 IXF and import it on to a v5.2 database which
knows only about version 1 IXF format.

Any suggestions, help is much appreciated.

Regards.


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.