SEARCH    
Avnet® Technology Solutions
IBM DB2 (1000 clients)

Contact Finder

Avnet contacts found : ?

Developer’s guides to migration

The following are a useful set of principals to migration for developers and IT managers:

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 Windows
Read: Run Oracle applications on DB2 9.7 for Linux, UNIX, and Windows
Read: Oracle to DB2 conversion guide: Chapter 2, "Language compatibility features"
Watch: DB2 9.7 SQL Compatibility Demo
Watch: Moving to DB2 is Easy


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.

Download: DB2 for Linux, UNIX, and Windows
Read: DB2 solution Information Center - Database fundamentals, "Installing"


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.7
Read: Oracle to DB2 conversion guide: Section 4.2, "Enabling SQL compatibility

 
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 systems
Read: Oracle to DB2 conversion guide: Section 4.3, "Creating and configuring the target DB2 database


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 analyses 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 utility
Download: IBM MEET DB2 assessment tool


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 Tool


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 Tool
Read: Oracle to DB2 conversion guide: Section 3.1.1, "Moving DDLs and data with the IBM Data Movement Tool


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"
Read: Tips and tricks for solving migration issues due to Oracle features


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"


Call Avnet today to speak to an advisor: + 44 (0)113 251 3051
Email: ibm-enquiries-uk@avnet.com

Watch: Moving to DB2 is Easy

Contact Us

IBM Sales

Avnet Technology Solutions

+ 44 (0)1344 662 122 

ibm-enquiries-uk@avnet.com

CRN Q&A
Right Bottom Fact sheet
Follow us on LinkedIn RSS Follow Avnet TS UK on Twitter YouTube
       

Bookmark and Share

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your browser settings we will assume that you are happy to receive all cookies on the Avnet Technology Solutions website. However, if you would like to, you can change the cookie settings of your browser at any time. To find out more about the cookies, see our Privacy Policy and Cookie Statement.

Agree