Modifying Schema Entities › Area Modifications › Adding or Deleting an Area

Adding or Deleting an Area

What Components are Affected

Adding or deleting an area in the schema affects the schema and subschemas referencing the area to be deleted, segments describing related physical databases, and DMCLs in which those segments are included.

Steps to add an area

1. Modify the schema
2. Add the new area
3. Define one or more records or system-owned indexes associated with the area
4. Validate the schema
5. Add the new area to one or more subschemas
6. Format the new area using the FILE option of the FORMAT utility statement

Steps to delete an area

1. Modify the schema
2. Modify existing records mapping to the area to be deleted so that they map to a different area
3. Delete the area
4. Validate the schema
5. Regenerate any affected subschemas

Considerations

• If existing records are to reside in a new area, see 33.5.6, “Changing a Record's Area".
• If an existing index is to reside in a new area, see 33.7.2, “Changing the Location of an Index".
• After you have added an area to a schema or deleted an area from a schema, make sure you update the DMCL module appropriately.