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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
