How to load multiple binary dump files

[balebob]

We use binary dump to dump all data on one of our bigest table called 'customer' which is about 13 GB. We got about 7 binary dump files with suffix like .db1, .bd2 etc.

My question is how do we load all these bin file back into the table? And should we load the last file first (.bd13) or loading from the beginning?

Thanks,
Bob.

 

[TomBascom]

You will use proutil dbname -C load filename to load the binary dump files. You just need to write a script that loads each of them individually:

proutil dbname -C load table.bd1
proutil dbname -C load table.bd2
proutil dbname -C load table.bd3
proutil dbname -C load table.bd4

The order doesn't really matter to the load process but it might matter to your application if you are trying to get the records in physical order (which is generally at least part of the reason for doing a d&l). In that case you want to go from smallest to largest number.