Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to convert DB2 9.5 to DB2 10.5 online (Linux) ? This can be done with IBM InfoSphere Data Replication? Has anyone done this or have any idea how to do?

share|improve this question
Are saying that you need to perform a version upgrade but can't take an outage (which is required) to do it, so you're looking for other options? – Ian Bjorhovde Nov 17 '13 at 13:01

You cannot migrate the database online.

You can use InfoSphere DR or any other replication software for migration with minimal downtime, however, if your application itself does not support transparent connection failover you will still experience a brief outage.

The process in brief would look like so:

  • Install DB2 10.5.
  • Create a new database in a DB2 10.5 instance, using db2look.
  • Install and configure replication software.
  • Perform a full refresh from the old (V9.5) database to the new one.
  • Continue mirroring until the new database catches up to the old one.
  • Initiate application failover.
  • Stop replication once the application has fully failed over.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.