Understanding DB2®: Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access