Database administration

Chapter 8.

In this chapter, we focus on the database administration features of a DB2 UDB, 

keeping in mind all the MySQL features. We provide a general introduction to 

MySQL administrations programs, utilities, and tools, and then provide a detailed 

description of DB2 UDB options corresponding to them. We also cover a few of 

the salient features available in DB2 UDB but missing in MySQL.

We present key attributes of database administration for both MySQL and DB2 

UDB such as:

Database recovery

Database replication

Data movement utilities

High availability

Automated tasks/jobs

Database configuration

We also explore following graphical and command line tools:

MySQL phpMyAdmin and Control Center

DB2 UDB Control Center

DB2 UDB Web Command Center

  Copyright IBM Corp. 2004. All rights reserved.

235