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

The LOAD Utility

The LOAD utility is used to accomplish bulk inserts to DB2 tables. It can add rows to a table, retaining the current data, or ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.