We help IT Professionals succeed at work.

Covert DB2 AIX  backup to DB2 9.5 for Windows

harsha_james
harsha_james asked
on
880 Views
Last Modified: 2013-11-15
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.
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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 OlsenData Warehouse / Database Architect
CERTIFIED EXPERT

Commented:
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
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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.