Chapter 33. Data Organization Utilities

 <  Day Day Up  >  


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

 <  Day Day Up  >  

DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388
Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net