Changing the space allocation for user-managed data sets

If the table space is supported by user-managed data sets, you must complete several steps to change the space allocation.

Procedure

To change the space allocation for user-managed data sets, complete the following steps:

  1. Run the REORG TABLESPACE utility, and specify the UNLOAD PAUSE option.
  2. Make the table space unavailable with the STOP DATABASE command and the SPACENAM option after the utility completes the unload and stops.
  3. Delete and redefine the data sets.
  4. Resubmit the utility job with the RESTART(PHASE) parameter specified on the EXEC statement.

What to do next

The job now uses the new data sets when reloading.

Use of the REORG utility to extend data sets causes the newly acquired free space to be distributed throughout the table space rather than to be clustered at the end.