Skip to main content

Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 09 August 2007

  1. .PDF (6.1 MB)

Share this page:   

ISBN-10: 0738489271
ISBN-13: 9780738489278
IBM Form #: SG24-7048-01

Authors: Whei-Jen Chen, An Na Choi, Marina Greenstein, Scott J Martin, Fraser McArthur, Carlos Eduardo Abramo Pinto, Arthur V Sammartino and Nora Sokolof

    menu icon


    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:

    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.

    Table of Contents

    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


    Others who read this also read