Oracle to DB2 UDB Conversion Guide

✍ Scribed by IBM Redbooks, Whei-Jen Chen

• Publisher: IBM.Com/Redbooks
• Year: 2003
• Tongue: English
• Leaves: 722
• Series: IBM Redbooks
• Category: Library

✦ Synopsis

DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbook is an informative guide that describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. This guide presents the best practices in migration strategy and planning, migration tools, and practical migration examples. It is intended for technical staff who are involved in an Oracle to DB2 UDB conversion project.This Redbook provides migration planning guidelines, with step-by-step instructions for installing and using IBM Migration Toolkits (MTK) to port the database objects and data from Oracle to DB2 UDB. 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, which are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning.