NOTE: There is a new conversion guide available for DB2 9.7 - Oracle to DB2 Conversion Guide: Compatibility Made Easy which can be found at: http://www.redbooks.ibm.com/abstracts/sg247736.html

IBM DB2 has long been known for its technology leadership. This IBM Redbooks publication, intended for technical staff who are involved in an Oracle to DB2 conversion project, is an informative guide that describes how to migrate the database system from Oracle to DB2 Version 9 on Linux, UNIX, and Microsoft Windows platforms.

This book provides conversion methodology and step-by-step instructions for installing and using IBM Migration Toolkit (MTK) to port the database objects and data from Oracle to DB2. It illustrates, with examples, how to convert the stored procedures, functions, and triggers. Application programming and conversion considerations are discussed, along with the differences in features and functionality of the two products.

In addition, you can find script conversion samples for data loading, database administration, and reports that are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning. The laboratory examples are performed under Oracle 10g and DB2 Version 9. However, the migration process and examples can be applied to Oracle 7, 8, and 9i.

Chapter 1. Introduction

Chapter 2. Conversion methodology

Chapter 3. MTK

Chapter 4. Porting with MTK

Chapter 5. Conversion reference

Chapter 6. Data conversion

Chapter 7. Application conversion

Chapter 8. XML conversion

Chapter 9. Script conversion

Chapter 10. Testing

Chapter 11. Database administration and management

Appendix A. Data types

Appendix B. Terminology mapping

Appendix C. Function mapping

Appendix D. Oracle Call Interface (OCI) mapping

Appendix E. Converter for SQL*Loader

Appendix F. Example Oracle database

Appendix G. Additional material