Oracle to DB2 Conversion Guide For Linux, Unix, & Windows, 746 Pgs

0.0

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

0.0

s 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 withthe 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.