Utility Statements › UNLOAD › Usage › The Unload/Reload Subschemas

The Unload/Reload Subschemas

The UNLOAD utility uses information in the dictionary when processing an SQL-defined database. When processing a non-SQL-defined database, the unload and reload subschemas must include the items listed next.

The unload subschema

The subschema used in an unload operation must:

• Include the areas being unloaded
• Include all areas containing records with set connections to records in the areas being unloaded
• Define all record types in the areas being unloaded
• Define all sets in which the record types participate
• Define all record types which can participate in the defined sets

The reload subschema

The subschema used in a reload operation (specified by RELOAD INTO..USING) must:

• Define the same record types and sets as the unload subschema
• Include the areas to be reloaded and all areas containing records with set connections to those areas.
• Allow all included areas to be readied in exclusive update mode

Unloading a dictionary

When unloading a dictionary, the IDMSNWKU subschema should be used for all areas, except DDLCAT, DDLCATX, and DDLCATLOD.

The DDLCAT and DDLCATX areas should be unloaded and reloaded using the IDMSCATZ subschema.

The DDLCATLOD area should be unloaded and reloaded using the IDMSCATL subschema. Before reloading the DDLCATLOD area in a segment defined for SQL, you must install stamps either by formatting by area or using the INSTALL STAMPS utility.