asked on

Covert DB2 AIX backup to DB2 9.5 for Windows

I have DB2 backup from AIX box as "B352AQM6.0.DB2.NODE0000.CATN0000.20090806112922.001"
and my problem is I have to restore it on Windows machine with DB29.5.
Please help me with procedure to do the task.

ASKER CERTIFIED SOLUTION

momi_sabag

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

harsha_james

ASKER

ok, plz check following steps or OK or not,
1) Use db2move to export all table data to PC/IXF files
2) Use db2look to generate DDL for all the database objects.
3) Use db2cfexp to export the configuration information to a file.
4)Transfer PC/IXF files & Configuration profile in Binary Mode.
5) Transfer db2look.sql & db2move.lst in ASCII Mode

But After doing all this on Windows machine , what if AIX db2 is of 9.1 and I want to do the import task on Windows with db2 9.5.

Kent Olsen

Hi harsha_james,

The fundamental structure of any 9.x system should be compatible with any other 9.x system so that you shouldn't have any issue. When IBM next changes the DB2 internals so that the directory structure, block header, row header, etc. is altered, you'll see DB2 version 10.x.

Kent

momi_sabag

you can do it
the PC/IXF format is platform and version independent,
DDL statements generated by db2look on a low vesion should work for a higher version
and the configuration should also work since depcrated configuration paramters ususally stick around a couple of versions for backward compatiability