Few days back i got an ixf file with no clue, and i was thinking that this solution will helps others too. Though this post will divert the way I am blogging....
The PC version of IXF (PC/IXF) file format is a database manager adaptation of the Integration Exchange Format (IXF) data interchange architecture. The IXF architecture was specifically designed to enable the exchange of relational database structures and data. The steps below demonstrate to create ixf file for a table 1,
- Start->All Programs -> IBM DB2 -> DB2Copy -> Command Line Editor
- Click on Control center icon -> Be sure the advance radio button is selected -> click OK
- Create a output/message file (logout.log)
- Open you database -> Tables -> Right Click on table -> Export
- A window will open -> browse the output file where you want the ixf file will be created Output file section,
- Select radio button Integrated Exchange Format under file format section and select the message file (you have just created logout.log) -> Click OK.
The steps below demonstrating to create table with data using ixf file.
Follow the step till 3 mentioned above and then the below:
- Right click on tables folder under database -> Create from import
- A window will open, locate the ixf file in Import file and locate the message file (logout.log here)
- Goto Table Specification tab -> Enter the table name and click ok.
