Oracle To Db2 Conversion Guide For Linux, Unix, And Windows

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

About the Authors
Whei-Jen Chen is a Project Leader at the International Technical Support Organization, San Jose Center. She has extensive experience in application development, database design and modeling, and DB2 system administration. Whei-Jen is an IBM Certified Solutions Expert in Database Administration and Application Development, as well as an IBM Certified IT Specialist.

An Na Choi is a Field Technical Sales Specialist with the Information Management department of SWG in South Korea. After graduating from the university, she worked for a local IT company for two years developing an encyclopedia application. An Na has supported DB2 and Informix products including DB2 Database server, Tools, WebSphere Information Integrator and Informix Dynamic Server, and DB2 for SAP for eight years. As a presales engineer, An Na has performed benchmark tests and participated in Oracle to DB2 conversion projects. She has extensive experience in deploying IBM Information Management solutions to many customers with DB2, Informix Dynamic Server, DB2 on SAP, WSII and many other tools.

Marina Greenstein is a Senior Certified Consulting IT Software Specialist with the IBM Database Migration Team. She is an IBM Certified Solutions Expert who joined IBM in 1995 with experience in database application architecture and development. During the 11 years Marina has been with the DB2 Migration Team, she has assisted customers in their migrations from Microsoft SQL Server, Sybase, or Oracle databases to DB2. She has presented migration methodology at numerous DB2 technical conferences and at SHARE. She is also the author of multiple articles and a white paper about DB2 migration.

Scott J Martin is a DB2 Technology Consultant with the IBM Innovation Center (IIC) for Business Partners in Waltham, MA, which is part of IBM Developer Relations. He has 25 years of IT experience with IBM, and is a certified Advanced Database Administrator for DB2 LUW V8.1, a certified Application Developer for the UDB Family, and a certified Database Administrator for DB2 for z/OS. For the past four years with the IIC, Scott has helped business partners convert their applications from Oracle, SQL Server, and MySQL to DB2 for LUW and DB2 for z/OS. In this role, Scott has also managed DB2 performance enablements and performed a variety of architecture and database administration tasks supporting business partners. Prior to this, he spent 13 years with IBM Global Services performing Application Development, Database Administration, and Database Tuning for DB2 mainframe environments.