Progress
Database Administration
Guide and Reference


Loading Table Contents With the PROUTIL Command

Use the following PROUTIL command to perform a binary load:

proutil db-name -C load filename 

db-name

Specifies the database where you want to load the data. You must completely define the path.

filename

Specifies the binary dump file that you want to load. You must completely define the path.

To load multiple binary dump files into the target database, specify each file individually. For example:

proutil db-name -C load customer.bd 
proutil db-name -C load customer.bd2 
proutil db-name -C load customer.bd3 
proutil db-name -C load customer.bd4 

When the load procedure finishes, it reports the number of records that were loaded.

NOTE: To update the index entries in the database when performing a binary load, use the BUILD INDEXES qualifier. For more information on the BUILD INDEXES qualifier, see the "PROUTIL LOAD Qualifier" section in Database Administration Utilities."

Recovering From an Aborted Binary Load

The procedure to recover from an aborted binary load depends on how much the binary load completed before the abort. If the binary load got all the rows loaded and aborted during the sort phase, then recovery entails running the index rebuild utility on the effected table. If the binary load aborted during the load of the rows into the database follow these steps:

  1. Truncate the storage area.
  2. Restart the load operation.

You can find out what phase the binary load completed by examining the database log (.lg) file. In this file, you will see messages identifying the major phases of the load operation, such as:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095