dump & Load with bulkload

N

nickjean

New Member
Hello,

I have a problem. my database is greater as 2 GB. If I dump my database with bulk, then I cannot load these with bulkload, because Progress does not support database greater as 2 GB. How can I split my database by dump the df-Files? I use progress 101B and 101A

thanks
 
The bulk loader is an "unusual" way to dump & load. Yes, it still exists but it's really not a very good way to get a d&l done.

Use binary dump & load. Or use something like the dump & load tool here:

Dump & Load

Progress does support databases greater than 2GB. Progress also supports extents greater than 2GB. You may need to use proutil to enable large files. Progress large file support is, of course, contingent on the underlying OS and filesystem supporting large files too.
 
What do you mean with reorganise?
Bulkload doesn't do that either.

Just look into the examples/presentations at Toms site and search PSDN for RPB and dump/load you find plenty of good documentation and examples.

Baiscally you have to do the following:
  1. you need to plan what storage area's you need acording to tablesize and rpb.(use type II storage area's).
  2. Dump the data definitions
  3. Dump _user and seqvals
  4. Dump the data binary
  5. Create new database with the the structure file from 1 with the correct blocksize (4 or 8 K, depending on OS)
  6. Modify df file acording to new database structure
  7. Load the data
  8. Load _user and seqvals
  9. rebuild indexes
Before you do this it is important to read up on why you want to do a dump and load and what is the best aproach in your situation.

Casper.
 
Binary dump & load reorganizes data the same as any other method (by "reorganize" I presume that you are referring to reordering and defragmenting the data).

But, as Casper says, you still need to plan out a database structure first.

The main thing that is different about a binary dump & load is that the intermediate files are not nicely formatted to be human readable. This makes them slightly faster for Progress to deal with. (Prior to v9 it made them a *lot* faster.) The .bd files are portable between operating systems and the results of a binary dump & load are just as effective as a dictionary d&l or a bulk load.

In my experience bulk load is hardly ever used. A few ancient partner applications had some automated tools that used it but beyond that it is exceedingly rare and not the method of choice.

As for which tools to look at on the Greenfield Technologies download page... I'd start with the Dump & Load PPT and Sample Code.

Actually, from the sound of things, you would probably be well served to hire a consultant to come in and show you how to do this... ;)
 
You must log in or register to reply here.
Back
Top