media/image4.png

After monitoring the space usage of extents, you may have to add more extents to your database to support its growth.

  • You can add new extents to existing data storage areas or you can add new data storage areas to the database.
  • If your database is enabled for after-imaging, you cannot add new data storage areas. However, you can add extents to existing data areas.
  • If your business environment requires that your database be available all the time, then you must add extents online.
  • If your business environment allows you to have regular downtime for routine maintenance, then you can add extents offline.
Note: IIf you want to modify extents such as to change the records per block, blocks per cluster, storage area names, or number and size of extents, you need to create a new .st file with the required extent attributes, create a new database using the .st file, and perform a dump and load.