Front cover -- Contents -- Figures -- Tables -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 DB2 Universal Database -- 1.1.1 Product overview -- 1.1.2 DB2 UDB for Linux, UNIX, and Windows architecture -- 1.1.3 DB2 utilities -- 1.1.4 DB2 database access -- 1.2 MySQL database -- 1.2.1 MySQL architecture -- 1.2.2 MySQL design and SQL compliance -- 1.2.3 MySQL utilities -- 1.2.4 MySQL application programming interfaces (API) -- Chapter 2. Planning the migration from MySQL to DB2 UDB -- 2.1 Migration project planning overview -- 2.1.1 Benefits of migrating to DB2 UDB -- 2.1.2 IBM migration offering -- 2.1.3 Education -- 2.2 Application assessment -- 2.3 System planning -- 2.3.1 Software -- 2.3.2 Hardware -- 2.3.3 Migration tools -- 2.4 The migration process -- 2.4.1 Porting preparation and installation -- 2.4.2 Database structure porting -- 2.4.3 Data porting -- 2.4.4 Application porting -- 2.4.5 Basic administration -- 2.4.6 Testing and tuning -- Chapter 3. Migration scenario -- 3.1 Application description -- 3.1.1 Steps using the application -- 3.1.2 Database structure -- 3.2 System environment -- Chapter 4. Installation -- 4.1 DB2 UDB ESE V8.1.4 on Linux -- 4.1.1 System requirements -- 4.1.2 Installation procedure -- 4.1.3 Instance creation -- 4.1.4 Client setup on Linux -- 4.2 Other software product -- 4.2.1 PHP adjustment for Unified ODBC with DB2 support -- 4.3 MTK installation and usage -- 4.3.1 MTK prerequisites -- 4.3.2 MTK installation -- Chapter 5. Database porting -- 5.1 Data type mapping -- 5.2 Data Definition Language differences -- 5.2.1 Database manipulation -- 5.2.2 Table manipulation -- 5.2.3 Index manipulation -- 5.3 Other considerations -- 5.4 Porting database -- 5.4.1 Automatic conversion using porting tools.

5.4.2 Manual porting -- 5.4.3 Metadata transport -- 5.5 Sample database migration -- Chapter 6. Data porting -- 6.1 Considerations concerning data porting -- 6.1.1 Commands and tools supporting data porting -- 6.1.2 Differences in data formats -- 6.1.3 Differences in the user account management -- 6.2 Sample project: Doing the data porting -- 6.2.1 Export user data from MySQL -- 6.2.2 Map MySQL user data to DB2 user data -- 6.2.3 Create DB2 user -- 6.2.4 Export MySQL application data -- 6.2.5 Convert MySQL application data to DB2 format -- 6.2.6 Import application data into DB2 UDB -- 6.2.7 Basic data checking -- Chapter 7. Application porting -- 7.1 Differences and similarities in Data Manipulation Language -- 7.1.1 SELECT syntax -- 7.1.2 JOIN syntax -- 7.1.3 UNION Syntax -- 7.1.4 Subquery syntax -- 7.1.5 Grouping, having, and ordering -- 7.1.6 Strings -- 7.1.7 Implicit casting of data types -- 7.1.8 String concatenation and NULL values -- 7.1.9 Record deletion -- 7.1.10 Built-in functions and operators -- 7.2 Application source conversion -- 7.2.1 Converting MySQL Perl applications to DB2 UDB -- 7.2.2 Converting MySQL PHP applications to DB2 UDB -- 7.2.3 Converting MySQL Java applications to DB2 UDB -- 7.2.4 Converting MySQL C/C++ applications to DB2 UDB -- 7.2.5 Converting MyODBC applications to DB2 UDB -- 7.2.6 Condition handling in DB2 -- 7.2.7 Special conversions -- 7.3 Additional application considerations -- 7.3.1 What is the purpose of locking? -- 7.3.2 Concurrency control and transaction isolation -- 7.3.3 DB2 isolation levels -- 7.3.4 Locking -- 7.3.5 Specifying the isolation level in DB2 -- Chapter 8. Database administration -- 8.1 Database recovery -- 8.1.1 MySQL recovery -- 8.1.2 DB2 UDB database recovery -- 8.2 Database replication -- 8.3 Data movement -- 8.3.1 MySQL data movement -- 8.3.2 DB2 UDB data movement -- 8.4 High availability.

8.5 Automated tasks/jobs -- 8.6 Database configuration -- 8.6.1 MySQL configuration -- 8.6.2 DB2 UDB configuration -- 8.7 Database management tools -- 8.7.1 MySQL phpMyAdmin and Control Center -- 8.7.2 DB2 UDB Control Center -- 8.7.3 DB2 UDB Web Command Center -- Chapter 9. Testing and tuning -- 9.1 Test planning -- 9.1.1 Principles of software tests -- 9.1.2 Test documentation -- 9.1.3 Test phases -- 9.1.4 Time planning and time exposure -- 9.2 Data checking techniques -- 9.2.1 IMPORT/LOAD messages -- 9.2.2 Data checking -- 9.3 Code and application testing -- 9.3.1 Application code check -- 9.3.2 Security testing -- 9.3.3 Tools for testing and problem tracking -- 9.4 Troubleshooting -- 9.4.1 Interpreting DB2 informational messages -- 9.4.2 DB2 diagnostic logs -- 9.4.3 DB2 support information -- 9.4.4 Problem determination tools -- 9.5 Initial tuning -- 9.5.1 Table spaces -- 9.5.2 Physical placement of database objects -- 9.5.3 Buffer pools -- 9.5.4 Large transactions -- 9.5.5 SQL execution plan -- 9.5.6 Configuration Advisor -- 9.5.7 Index Advisor -- Chapter 10. Advanced DB2 UDB features -- 10.1 Views -- 10.2 Stored procedures -- 10.3 Trigger -- 10.4 User-defined data types (UDT) -- 10.5 User-defined functions -- 10.6 Materialized query tables (MQT) -- 10.7 Multidimensional clustering (MDC) -- Appendix A. Sample code for user defined functions -- A.1 Sample code for BIT_AND -- A.2 Sample code for FORMAT function -- A.3 Sample code for RPAD and LPAD functions -- A.4 Sample code for GREATEST function -- A.5 Sample code for LEAST -- A.6 Sample code for BIT_COUNT -- A.7 Sample code for SUBSTRING_INDEX -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.