The goal of this chapter is to introduce the architecture and design of both 

database engines: MySQL and DB2 Universal Database  (DB2 UDB). This 

chapter includes the following points:

DB2 UDB 8.1

  DB2  family

  DB2 architecture

  DB2 utilities

  DB2 client access

MySQL database

  MySQL architecture

  MySQL design and SQL compliance

  MySQL utilities

  MySQL client application programming interfaces (API)

1.1  DB2 Universal Database

DB2 UDB is a high scalable database, developed to meet even the highest 

demands that a most critical database application can have. DB2 UDB however 

is also an easy installable and manageable RDBMS. The goal of this section is to 

give an idea about DB2 UDB, its architecture, tools, and client connectivity.

1.1.1  Product overview

DB2 UDB on Linux, UNIX , and Windows span the spectrum and range all the 

way from products on handheld devices to large clusters and mainframes (see 

Figure 1 1). More detail information can be found at: 

http://www 306.ibm.com/software/data/db2/udb/

2 

MySQL to DB2 UDB Conversion Guide