DB2 Server for VSE & VM: Database Services Utility


Chapter 3. Unloading Data with the Database Services Utility

This chapter describes the DATAUNLOAD command first, and then describes the UNLOAD commands, beginning with UNLOAD Procedures.

To selectively unload data from tables and views, use the DATAUNLOAD command. The DATAUNLOAD command creates a sequential file of data that you can modify and reload into a table with the DATALOAD command.

If you want to create a backup for specific dbspaces or tables, use the UNLOAD command. The UNLOAD command also allows you to move data in units of tables (one table or all the tables in a dbspace) to another database manager. If you want to reclaim fragmented disk space or reorder data records to match indexes, use the UNLOAD command followed by the RELOAD command.

Refer to the appropriate sections of the earlier chapters for details about invoking the Database Services Utility and defining files.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]