Chapter 12. Maintaining Data
• EXPORTING DATA
• IMPORTING DATA
• LOADING DATA
• ANALYZING DATA PLACEMENT
• REORGANIZING DATA
• GATHERING STATISTICS
In this chapter, the techniques of how to populate and extract DB2 data using the
EXPORT utilities will be examined. The differences between these utilities will be examined along with the scenarios that would favor using one over another.
Additional maintenance topics will include examining the physical data placement and gathering statistics. Some of the utilities examined will include
Whenever data is extracted or inserted into the database, particular care must be taken to check the format of the data. Sometimes a DBA may spend ...