Progress
Database Administration
Guide and Reference
Loading Table Contents With the PROUTIL Command
Use the following PROUTIL command to perform a binary load:
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:
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:
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 |