Figure 8 2   DB2 UDB roll forward restore

This can be achieved by executing the rollforward command after the backup 

image is restored as shown below:

db2>rollforward database itsodb2 complete

Tip:

 DB2 UDB backup and restore can also be done using Control Center.

8.2  Database replication

Database replication is a process of maintaining the database in multiple 

systems. It involves synchronizing changes from one database (a source) to 

another database (a target). This feature is very useful for load sharing, fast 

disaster recovery, and high availability. 

MySQL allows one way replication between two MySQL servers only. It is based 

on the master server keeping track of all the changes to the database in the 

binary log; and all the slave servers need to get this binary log from the master 

server and rerun all the statements on the slave database from the previous 

stable state. The slave server can be set up using the 

LOAD DATA FROM MASTER

command; this is supported only for the MyISAM table type. Once the slave 

setup is done and running, it will connect to the master and wait for updates to 

process. This is a continues process and the slave will always listen for an 

update.

DB2 UDB supports replication using publish subscribe replication setup, wherein 

you can replicate data not only in two DB2 UDB systems running on different 

platforms, but also on the following non DB2 databases: Informix, Microsoft Jet, 

Microsoft SQL Server, Oracle, Sybase, and Sybase SQLAnywhere.

DB2 UDB provides a tool called the DB2 UDB 

Replication Center

; it is a tool 

which can be used to set up and administer your replication environment, and to 

240 

MySQL to DB2 UDB Conversion Guide