Use the Load Process to transform the contents of an Archive File to Load utility format and execute a Load utility.
You can use a load utility from IBM® or from another software vendor. If using LOADPLUS, you are presented with panels specific to LOADPLUS. (The LOADPLUS panels are discussed in Perform LOADPLUS Utility.)
Using the Load utility instead of the Archive Restore Process may provide benefits under certain conditions:
Both the Load utility and the LOAD phase of LOADPLUS must be in exclusive control of the database to function. During the Archive Restore Process, however, the database remains available to all users. Many of the Restore Process facilities are available when using a Load utility. Table Maps can be used to specify different Creator IDs and table names for the destination. Column Maps can be used to specify different column names. A Load utility is a batch utility that inserts rows in the destination database. It cannot be used to replace data.
Generally, rows in the Archive File are loaded into the database in the order processed. However, if a cluster index has been defined for the table, the rows can be sorted on the basis of that index before they are loaded. LOADPLUS provides sort options that you can select when defining parameters for the load.