I´m using baan Vc2 mcr. The tables are huge so I can´t perform a simple secuential dump for all tables. So I create many of the secuential tables dump in order to cover all of them.
My question is.- Is there any tool to perform this automatically?

Hi mig28mx,

yes there is such a tool:
bdbpre6.1 :D

If your portingset isn't too old, you can use the option -M to define the maximum size of a dumpfile.
You can see the possible options and the syntax with bdbpre6.1 -U.

Hi Gerhard,
Thanks for your reply. Yes I can use bdbpre6.1 but, what happen when the file reach the maximum allowed? In Unix the limit are 2gb, right?

We used to have the same problem.

We would use bdbpre6.1 in a script. The script would create a pipe, bdbpre6.1 would output to the pipe and then the script would cat the pipe to compress to the final output file.

If the file winds up being still too large, you can use bdbpre6.1 with a the -I option. -I is the input file. In the input file, list all the tables you want to dump. Set up multiple input files and run the script for each of the input files to create smaller dumps.



/etc/mknod $tmpdmp p
cat $tmpdmp | compress > $thedmp &

bdbpre6.1 -o $tmpdmp -Itables.txt