Get an overview of the DB2 compatibility features that make it possible to move Oracle-based applications to DB2, virtually unchanged.
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.
Before creating your DB2 database, you need to enable the Oracle Compatibility mode for your DB2 instance.
Explore the DB2 environment, learn how to create a database, and become familiar with the DB2 configuration tools and settings.
Use the IBM Database Conversion Workbench (DCW) to assess the compatibility 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.
Install the IBM Database Conversion Workbench on your target database server. DCW integrates many of the tools used for database migration into an easy to use plug-in for IBM Data Studio.
Use the IBM Database Conversion Workbench to extract DDL, table data, and PL/SQL objects from an Oracle database, convert incompatible code, and finally deploy the objects and data to DB2.
Check to make sure everything you migrated is working, and get hints and tips on how to re-solve issues that may arise.
Connect to the database in order to verify that the database objects and PL/SQL code were enabled successfully.
Rate this content
Give us feedback
Submission failed. Please try again.
Please complete one of the following questions before submitting.