لطفا منتظر باشید ...
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
