Modify operations require additional working disk space because a new version of the table must be built before the old table can be removed. In most cases, modify operations require about two or three times more space than the original table size. This is only an approximation; the amount of disk space actually needed can vary.

The free disk space is also required during modify to relocate and modify to reorganize operations.

For information about relocating and changing the location of storage structures, see the Modifying Storage Structures topic in online help for VDBA. For details on the DBA use of these operations, see Techniques for Moving a Table to a New Location.

In SQL, you can accomplish these tasks with the MODIFY TO REORGANIZE and MODIFY TO RELOCATE statements. For more information, see the SQL Reference Guide.

The maintain_locations privilege is needed to perform the operation on location objects in VDBA or to issue the MODIFY LOCATION statement in SQL. The maintain_locations privilege allows users to do the following:

Temporary files are created in both the data and work locations. For example, usermod copies data between II_DATABASE and II_WORK before replacing the original table.