Chapter12.Maintaining Data

Chapter 12. Maintaining Data

Moving data from one database server to another is a very common task in a production environment and in almost every phase of the development cycle. For example, a developer may want to export data from a production database and load it into her tables for testing. In a production environment, a database administrator may want to export a few tables from production to a test database server to investigate a performance problem.

DB2 provides a number of utilities so that you can accomplish these tasks very easily. We will introduce each utility and discuss different options supported.

In this chapter you will learn about:

• The big picture of the DB2 data movement utilities

• Different file formats used to move data

• The EXPORT utility

• The IMPORT utility

• The LOAD utility

• The DB2MOVE utility

• The DB2RELOCATEDB utility

• How to generate the Data Definition Language for a database

• The different data maintenance utilities