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
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
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