Loading table contents in binary format with PROUTIL

Database Administration

Maintaining and Monitoring Your Database : Dumping and Loading : Loading database contents : 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.

In this section:

Recovering from an aborted binary load