DB2 UDB provides an API for importing data from files exported using the 

export tool. This provides an option to do importing programmatically by using 

sqlutil.h, and a method sqluimpr.

The DB2MOVE utility

Data can be copied using the DB2 

EXPORT

 and 

IMPORT

 utilities. But a more 

efficient way to copy an entire DB2 UDB database is by using the DB2 

db2move 

utility. This utility queries the system catalog tables for the specified database, 

and exports the table structure and contents of each table found to a PC/IXF 

formatted file. These files can be used to populate another DB2 UDB database. It 

can be run in three modes:

EXPORT mode

In this mode, the 

db2move

 utility invokes DB2 

EXPORT

 utility to extract data from 

one or more tables and write to PC/IXF formatted files. It also creates a file 

named db2move.lst

that contains the names of all tables exported and the 

names of the files that the table s data was written to. 

EXPORT

 mode can be 

used as below:

bash>db2move itsodb2 export

IMPORT mode

In this mode, the 

db2move

 utility invokes DB2 

IMPORT

 utility to recreate tables 

and indexes from data stored in PC/IXF formatted files. The file db2move.lst 

generated in 

EXPORT

 mode can be used to get information about tables in the 

exported files. The above exported files can be imported using:

bash>db2move itsodb2 import

LOAD mode

In this mode, the

 db2move

 utility invokes DB2

 LOAD

 utility to populate tables 

that already exist with data stored in PC/IXF formatted files. The file 

db2move.lst

generated in 

EXPORT

 mode can be used to get information about 

tables. The above exported files can be loaded using:

bash>db2move itsodb2 load  l /home/itso/backup

8.4  High availability

High availability is a business requirement on the system to provide services all 

the time, and survive disaster, system crash, and glitches without or with minimal 

interrupting of the service. This is achieved by a number of techniques like online 

management of the database system, advanced instance management, 

suspended I/O, and clustered servers. 

246 

MySQL to DB2 UDB Conversion Guide