LOAD (Build CXX or Data Area)

The LOAD function has two options. They are:
The LOAD function has two options. They are:
  • Restore an entire Directory (CXX), or a Directory definition for a specific database.
  • Build a data area and its associated Index Area (IXX) entries.
More Information:
  • For more information about DBUTLTY STATUS console command support for this function, see COMM STATUS (Print Status of MUF Jobs).
  • For more information about the impact of table partitioning on the LOAD function, see the LOAD Utility. FILEIN can be used before a LOAD.
  • For more information about dynamic extend considerations with regard to this function, see DBUTLTY Dynamic Extend Considerations.
Use the LOAD function to perform the following:
  • Restore an entire Directory (CXX) from a backup made using the BACKUP function.
     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
    Ideal for Datacom
    , 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
    Ideal for Datacom
    documentation for details.
    To retain synchronization, when restoring the Directory, perform forward recovery.
    Datacom Datadictionary
    base 2 (normally), 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.
  • 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.