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 09 August 2007

cover image

ISBN-10: 0738489271
ISBN-13: 9780738489278
IBM Form #: SG24-7048-01
(744 pages)

View online

Other Language Versions

Note: Other language versions may not be as current as the English edition.

More options

Rate and comment

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


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

Follow IBM Redbooks

Follow IBM Redbooks