media/image9.png

To add extents to a database offline, you perform the following tasks:

  1. Create a .st file for the new extents.
  2. Validate the extents using PROSTRCT ADD VALIDATE.
  3. Shut down the database if it is online.
  4. If you have time, back up the database.
  5. Truncate the BI files of the database using PROUTIL TRUNCATE BI.
  6. Remove the variable extent, if it is empty, using PROSTRCT REMOVE.
  7. Add extents to the database using PROSTRCT ADD and the new .st file.
  8. Update the .st file of the database using PROSTRCT LIST.
  9. Restart the database.