Chapter 33. Data Organization Utilities

IN THIS CHAPTER

• The LOAD Utility

• The UNLOAD Utility

• The REORG Utility

The data organization utilities affect the physical data sets of the DB2 objects for which they are run. Rows of data and their sequence are affected by these utilities. The data organization utilities are LOAD , UNLOAD , and REORG . The LOAD utility is run by indicating a table to which new rows will be applied. UNLOAD reads rows from a table and puts them into an output data set. REORG is run at the table space or index level, moving data to optimal locations in the data set.