Moving a table between dbspaces with the onunload and onload utilities

You can use the onunload and onload utilities to move a table from one dbspace to another dbspace on the same computer.

Procedure

To move a table from one dbspace to another dbspace on the same computer:

  1. Run the onunload utility to unload the table.

    For details on the syntax of the onunload command, see Syntax of the onunload command.

  2. Turn off logging.

    When you are loading a table, logging on the target database must be turned off.

  3. Run the onload utility.

    Specify a new table name and new dbspace name in the onload command.

    For details on the syntax of the onload command, see Syntax of the onload command.

  4. If the data loads successfully, delete the old table in the old dbspace and rename the new table to the old table name.
  5. Create a level-0 backup of the modified database.
  6. Turn logging back on, if you want logging.