Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Dumping and Loading : Loading database contents : Loading table contents in binary format with PROUTIL
 
Loading table contents in binary format with PROUTIL
Use the following syntax to perform a binary load:
proutil db-name -C load filename [ -dumplist dumpfile]
In the syntax, db-name specifies the database where you want to load the data. To load one file, specify filename; to load multiple binary dump files, specify -dumplist dumpfile where dumpfile contains a list of binary dump files. You can chose to build indexes on your data as it loads with the build indexes parameter. For complete syntax details, see PROUTILLOAD qualifier.
When specifying multiple files to load, you can use a dump file created with a multi-threaded binary dump, or create your own. A dump file contains a list of fully qualified file names of binary dump files. This example shows the contents of the file order.dmp_lst:
/usr1/docsample/101A/bindump/order.bd
/usr1/docsample/101A/bindump/order.bd2
/usr1/docsample/101A/bindump/order.bd3
/usr1/docsample/101A/bindump/order.bd4
/usr1/docsample/101A/bindump/order.bd5
/usr1/docsample/101A/bindump/order.bd6
To load all the files listed in order.dmp_lst into a database named newdb, issue the following command:
proutil newdb -C load filename -dumplist order.dmp_lst
Using the -dumplist parameter is the equivalent of issuing 6 individual load commands. For example:
proutil newdb -C load /usr1/docsample/101A/bindump/order.bd
 proutil newdb -C load /usr1/docsample/101A/bindump/order.bd2
proutil newdb -C load /usr1/docsample/101A/bindump/order.bd3
proutil newdb -C load /usr1/docsample/101A/bindump/order.bd4
 proutil newdb -C load /usr1/docsample/101A/bindump/order.bd5
proutil newdb -C load /usr1/docsample/101A/bindump/order.bd6
When the load procedure finishes, it reports the number of records that were loaded.
* Recovering from an aborted binary load