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 LOAD
, IMPORT
, and 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 REORGCHK
, REORG
, RUNSTATS
, and REBIND
.
Moving Data
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 ...
Get DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.