Steps for moving extents

Moving extents must be done offline. To move extents to another location, you perform the following tasks:

1. Shut down the database.
2. If you have time, back up the database.
3. Update the .st file with information about the new location.
4. Manually move the extents to a new location.
5. Update the .db file using PROSTRCT REPAIR.
6. Restart the database.

You already know how to perform most of these steps. Next, you will learn how to update the .st file and update the .db file.