Modifying Schema Entities › Record Modifications › Changing a Record's Area

Changing a Record's Area

Types of Changes

You can move a record from one area to another or change the portion of an area in which a record is stored.

Note: If a subarea symbolic is associated with the record, you change the portion of the area in which the record is stored by changing the physical area definition and regenerating DMCLs. See Chapter 27, “Modifying Physical Database Definitions” for more information.

What components are affected

The schema record definition and data area affected. Subschemas and access module that reference the record are also affected.

Steps to change the record's area

To change the area (or portion of an area) in which record occurrences are stored when data has been loaded:

1. Create a new schema based on the original schema
2. Add the area, if necessary, to the new schema
3. Modify the record in the new schema to specify the new area or subarea/offset
4. Validate the schema
5. Create a new global subschema
6. Unload and reload the database
7. Complete the process by updating the original schema, regenerating affected subschemas, and altering affected access modules.

Considerations

• If you had to add the area to the schema, you must explicitly add it to subschemas associated with the record. You must also explicitly add the area to all applicable physical database definitions and regenerate affected DMCLs.
• If you increase the page range of a record whose location mode is other than CALC, you do not need to unload and reload the data provided the new page range includes all pages of the original range.