LOAD (Build CXX or Data Area) › LOAD (Build a Data Area) › Adding a Table to a Data Area

Adding a Table to a Data Area

To add a table to an existing area which already contains one or more tables:

1. Create a backup of the area using the BACKUP function. Specify SEQ=NATIVE or SEQ=PHYSICAL. If SEQ=PHYSICAL is specified, RECID=NO must be entered.
2. Load the new table into the area with LOAD.
3. Back up the area using BACKUP. Specify SEQ=NATIVE or SEQ=PHYSICAL. If SEQ=PHYSICAL is specified, RECID=NO must be entered.
4. Back up the data as a single file via a system utility, such as DITTO, SORT/MERGE, and so on. Use this file to load all the tables together.
5. If any of these tables share a Native Key ID or if the area is clustered, then you must do one additional backup with SEQ=NATIVE, and then load it to cluster the tables. If the area is clustered, specify CLUSTER=SPARSE.