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 live online training, plus books, videos, and digital content from nearly 200 publishers.