MySQL to DB2 UDB conversion guide / Whei-Jen Chen ... [et al.].

Format:

Book

Author/Creator:

Whei-Jen, Chen., Author.

Language:

English

Subjects (All):

SQL (Computer program language).

Database management.

MySQL (Electronic resource).

IBM Database 2.

Physical Description:

xx, 374 p. : ill.

Edition:

1st ed.

Place of Publication:

White Plains, N.Y. : IBM, c2004.

Language Note:

English

Contents:

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.

Notes:

"May 2004."

"This edition applies to IBM DB2 UDB Version 8.1 for Linux, UNIX, and Windows, MySQL Version 4.0, SuSE 8.0 and Red Hat 8.0."

"Complete guide to migrate MySQL database and application to DB2 UDB. Application enrichment through advanced DB2 UDB features. Application migration with detailed examples."

Includes bibliographic references and index.

OCLC:

756598830