O'Reilly logo

DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition by Paul C. Zikopoulos, George Baklarz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required