LOAD (Build CXX or Data Area) › Overview

Overview

Use the LOAD function to perform the following:

• Restore an entire Directory (CXX) from a backup made using the BACKUP function.

  Caution If you are using SQL to access data, restoring the Directory from a current backup without restoring the DATA-DICT and Data Definition Directory (DDD) databases from backups taken at the same time can result in loss of synchronization which is critical for SQL operations.

  If you are using CA Ideal, restore the Virtual Library System files from a backup that was taken at the same time as the backup of the Directory to assure synchronization. See the CA Ideal documentation for details.

  To retain synchronization, when restoring the Directory, perform forward recovery. Beginning with Version 11.0, LOAD by DBID may require more GETVIS than was required in previous versions.

  If you cannot perform forward recovery, restore all data areas in the DATA-DICT database, except the HSD, and all data areas in the DDD database. Then, use the -HSD RESET transaction of the DDCFBLD utility to rebuild the HSD (see the CA Datacom Datadictionary Batch Reference Guide).

• Restore an individual database definition to the Directory.
• Load a data area with data for a single table that is in EXTRACT (user) format. See EXTRACT (Extract Data Table) for more information.
• Null load a data area. This causes all of the area's tables to be marked usable, but empty. It loads one table with no input data.
• Reorganize a data area into Native Key sequence by table.
• Restore a data area from a previous backup.

Before loading a data area for the first time, initialize the area using the INIT function. For a newly allocated database, both the Index Area (IXX) and all data areas must first have been initialized. After the primary initialization, you can load areas as often as required without performing an INIT.