Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Select a language:

  • Close [x]
  • Close [x]

DB2 fundamentals for Oracle professionals: Migrating from Oracle to DB2

Date:  07 Oct 2011 (Published 22 Mar 2011) |Level: Intermediate ||

Sign in to save your progress (Learn more)

Saving your progress (Learn more)

1. Learn about DB2 compatibility with Oracle

Get an overview of the DB2 compatibility features that make it possible to move Oracle-based applications to DB2, virtually unchanged.

Read: Leverage your Oracle skills to learn DB2 for Linux, UNIX, and WindowsItem marked not complete - Click to mark complete

Read: Run Oracle applications on DB2 9.7 for Linux, UNIX, and WindowsItem marked not complete - Click to mark complete

Read: Oracle to DB2 conversion guide: Chapter 2, "Language compatibility features"Item marked not complete - Click to mark complete

Watch: DB2 9.7 SQL Compatibility DemoItem marked not complete - Click to mark complete

Watch: Moving to DB2 is EasyItem marked not complete - Click to mark complete

2. Install DB2 for migration

If you don't already have DB2, you can easily download and install our 90-day trial version of DB2 for Linux, UNIX, and Windows.

Sign inItem marked not complete - Click to mark complete

Read: DB2 solution Information Center - Database fundamentals, "Installing"Item marked not complete - Click to mark complete

3. Set SQL compatibility for DB2

Before creating your DB2 database, you need to enable the Oracle Compatibility mode for your DB2 instance.

Read: SQL Compatibility for DB2 9.7Item marked not complete - Click to mark complete

Read: Oracle to DB2 conversion guide: Section 4.2, "Enabling SQL compatibilityItem marked not complete - Click to mark complete

4. Create and configure target DB2 database

Explore the DB2 environment, learn how to create a database, and become familiar with the DB2 configuration tools and settings.

Read: DB2 solution Information Center - Database fundamentals, "Configuring DB2 database systemsItem marked not complete - Click to mark complete

Read: Oracle to DB2 conversion guide: Section 4.3, "Creating and configuring the target DB2 databaseItem marked not complete - Click to mark complete

5. Use assessment tool for migration preparation

Run the IBM Migration Enablement Evaluation Tool (MEET) to get a quick compatibility assessment of your current Oracle database with DB2. The tool analyzes all the objects in your Oracle database and scores them, then produces a report of what will work out of the box and where you will need to make adjustments.

Read: Oracle to DB2 conversion guide: Section 3.3, "MEET DB2 evaluation utilityItem marked not complete - Click to mark complete

Download: IBM MEET DB2 assessment toolItem marked not complete - Click to mark complete

6. Install and open data migration tool

Get the IBM Data Movement Tool at no charge and install it on your target database server. This tool helps you to easily enable applications from Oracle to run on DB2 as is, with very little or no changes.

Download: IBM Data Movement ToolItem marked not complete - Click to mark complete

7. Extract and deploy DDL, table data, and PL/SQL objects for migration

Use the IBM Data Movement Tool to extract compatible DDL, table data, and PL/SQL objects from Oracle and deploy them to DB2.

Read: IBM Data Movement ToolItem marked not complete - Click to mark complete

Read: Oracle to DB2 conversion guide: Section 3.1.1, "Moving DDLs and data with the IBM Data Movement ToolItem marked not complete - Click to mark complete

8. Review and resolve migration of DDL, table data, and PL/SQL objects

Check to make sure everything you migrated is working, and get hints and tips on how to re-solve issues that may arise.

Read: Oracle to DB2 conversion guide: Section 4.5.5, "Resolving incompatibilities with Interactive Deploy"Item marked not complete - Click to mark complete

Read: Tips and tricks for solving migration issues due to Oracle featuresItem marked not complete - Click to mark complete

9. Verify your migration

Connect to the database in order to verify that the database objects and PL/SQL code were enabled successfully.

Read: Oracle to DB2 conversion guide: Section 4.6, "Verification of enablement"Item marked not complete - Click to mark complete




Rate this content



Give us feedback

Submission failed. Please try again.

Please complete one of the following questions before submitting.

1. Are you finished with this knowledge path?

       

2. How much did you learn?

           

3. Tell us more

  • What did you like/dislike?
  • What can we do better?

2500 characters left

Disabled Submit button

Close [x]

Add to My dW interests

Submission failed. Please try again.

Topics:

  • DB2
  • Migration
  • SQL (Structured Query Language)

My profile

Close [x]

developerWorks: Sign in


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

Close [x]

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 

All information submitted is secure.

Close [x]

Save your progress Green checked checkmark

When you sign in, we will save this item to your developerWorks community home page and track your progress so you know what you've completed and where to resume when you return.

For a list of your saved items, see your My Home > My saved items page.

Close [x]

Thank you for your feedback. We appreciate your sharing your opinion with us.

Close [x]

Do you want to save your progress?

, Sign in to save your progress

Close [x]

Save your progress

Sorry. Our server is not available, and we cannot display your saved progress at this time.

Your progress will be displayed when the server is available again. Any previous progress is retained, and additional progress is being tracked.

If your most recent progress is not displayed within 24 hours, you can click the checkmark to indicate completion.

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your developerWorks profile. The general subjects of this content will be added to the interests section of your profile, along with the associated technical topics. You only need to be signed in to developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your developerWorks profile

Return from help

About this knowledge path

The tips and techniques in this knowledge path, along with tools that you can download from IBM at no charge, make it easy for you to leverage your existing knowledge of Oracle while successfully completing a migration from Oracle to DB2.

Activities in this path

  1. Learn about DB2 compatibility with Oracle
  2. Install DB2 for migration
  3. Set SQL compatibility for DB2
  4. Create and configure target DB2 database
  5. Use assessment tool for migration preparation
  6. Install and open data migration tool
  7. Extract and deploy DDL, table data, and PL/SQL objects for migration
  8. Review and resolve migration of DDL, table data, and PL/SQL objects
  9. Verify your migration

Related resources

Share this page:

  • Close [x]

Follow developerWorks:

  • Close [x]
static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=756185
publish-date=10072011