Chapter 34. Data Movement and Organization Utilities
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 impacted by these utilities. The data organization utilities are
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.
The LOAD Utility
LOAD utility is used to accomplish bulk inserts to DB2 tables. It can add rows to a table, retaining the current data, or ...