Understanding DB2: Learning Visually with Examples (2nd Edition)

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

Related

Категории