Load

This option is used to quickly load data into the RealTime database (RTDB) with minimal data validation. You can only use the load option on a RTDB server that is currently in the FAIL (or shutdown) state. Since no field level checks are performed, the load option is typically used only to restore data from files that are known to be valid.

A record in RTDB that has the same record number as a record in the text file that is used in loading the database will have all its field information overwritten even if it has a different unique key (normally the Name field).

If a record in the text file has a record number of zero (for example, its POINT# field is set to 0), a new RTDB record is created if this record’s unique key is different from the unique keys of any records that exist in the RTDB. Loading a text file with a record that has its POINT# field set to 0, but a unique key identical to the unique key of a record in the pre-existing RTDB, generates an error. As a result of the error, the system will not modify the existing database record or load the text file record.

Syntax

dbll load <data_file> <error_file>

The load option instructs the dbll program to read from the data_file containing the table record specification, field names and field values. The data_file can be in list or tabular format (created using the list or tabular options, or through a text editor). General tabular formats can also be used. Any errors that occur during the load are written to the file error_file.

Note: The dbll load utility can only be run on a RealTime computer that is not currently running (for example, RealTime service is neither Hot nor Standby). If run on a Hot or Standby RealTime service, dbll load prints a warning and exits; however, the dbll safeload utility can be used on a Hot RealTime service.