Download MySQL to DB2 UDB Conversion Guide

Download MySQL to DB2 UDB Conversion Guide

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 MySQL to DB2 UDB Version 8.1 on Linux, and how to convert applications to use DB2 UDB instead of MySQL.
This guide presents the best practices in migration strategy and planning, migration tools, and practical migration examples. It is intended for technical staff involved in a MySQL to DB2 UDB conversion project.
This redbook also provides step-by-step instructions for installing and using the IBM DB2 Migration Toolkit (MTK) to port the database objects and data from MySQL to DB2 UDB.
Application programming and conversion considerations are discussed along with the differences in features and functionality of MySQL and DB2 UDB.
Examples are used throughout the book to illustrate conversions of database access, database administration, SQL statements (DDL, DML) and others, as well as testing and tuning your DB2 UDB system.

Table of contents
Chapter 1. Introduction
Chapter 2. Planning the migration from MySQL to DB2 UDB
Chapter 3. Migration scenario
Chapter 4. Installation
Chapter 5. Database porting
Chapter 6. Data porting
Chapter 7. Application porting
Chapter 8. Database administration
Chapter 9. Testing and tuning
Chapter 10. Advanced DB2 UDB features
Appendix A. Sample code for user defined functions

Download