EXTEND (Extend Data or Index Areas) › When to Use

When to Use

Use the EXTEND function to increase the space available in a data or index area. You can use EXTEND:

• When planning for future growth.
• When an area becomes full or nearly full.

Note: A Multi-Dataset Index area (I00-99) can only be extended if the IXX Index Area is initialized and able to be open for processing. This requirement does not exist for the IXX Index Area and data areas.

In Simplify mode, the function expects MUF to be enabled. This provides control and protection. If MUF is not enabled, this function should wait for MUF to enable. If you have to execute the function without MUF enabled, for example if it is needed to allow restart to execute, the function must either follow a function that can only run with MUF not enabled or follow a function to acknowledge MUF is not enabled with SET OPTION1=MUF_NOT_ENABLED. It is possible (but not recommended) to use SET OPTION1=MUF_ENABLED_OR_DISABLED. The function without MULTUSE=YES and MUF enabled does not require or want the database to be closed but there must be no open URT for any table in the base.