IBM Mastering Data Management with db2move: Export, Import, and Load Commands in DB2

Exporting data with db2move

By default, db2move exports all the user tables and is always using the IXF file format. The outcome of an export by db2move is the outcome of the underlying calls to the export utility and a text file db2move.lst, which contains the mapping between the tables and the export files. Example 5-17shows how to export our sample database using the db2move utility.

Example 5-17 Exporting all tables using the db2move utility

db2move itsodb export

Importing data with db2move

In Example 5-18we show how to use db2move to import data to our sample database. db2move looks for the file db2move.lst and import the tables specified in that file. The default import mode is replace. Here we use the insert mode instead by specifying the option -io insert to the db2move command.

Example 5-18 Importing all tables using the db2move utility

db2move itsodb import -io insert

Note: The db2move.lst file created by db2move when using the export action has the tables sorted by table name. You might have to rearrange the table sequence in db2move.lst before it can be used for import.

Loading data with db2move

In Example 5-19we show how to use db2move to load data to our sample database. db2move looks for the file db2move.lst and load the tables specified in

that file. db2move performs load only. You have to run the set integrity command if there are tables in the integrity pending state after the load.

Example 5-19 Loading all tables using the db2move utility

db2move itsodb load

set integrity for itso.employee allow no access immediate checked; set integrity for itso.adefusr allow no access immediate checked;

For a thorough description of db2move, refer to the DB2 Infocenter:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admi

n.cmd.doc/doc/r0002079.html

Chapter 5. Deploying pre-configured databases 239