G'Day!

Can someone please let me know what these two tools are?

bdb_pre and bdb_post

Is there any documentation anyone has on them? I want to know about them in detail.

Cheers!

Hi there,

good choice to learn about these programs :-:
bdbpre dumps tables to ascifiles, bdbpost does the exact opposit, reading files into tables.
Just enter bdbpre6.1 -U or bdbpost6.1 -U to see the parameters. (Make sure that your environment parameters $BSE and $BSE_TMP are set correctly)
BTW, the sessions "Create sequential dump of table" and "Create table from seq. dump" do use these programs.

regards

Norbert

Bdbpre tool copies data from database to ASCII file and bdbpost can import such data from ASCII file to a database.
Start session Create sequential Dump of Table (ttaad4226m000) and session Create Table from sequential Dump (ttaad4227m000) and read sessions help.

Thank mates! I was wondering did someone ever document it at all..something like pdf/doc. I guess these are pretty sensitive tools to handle and you can easily screw up if you are not careful.

I was wondering if a bdb_pre on a table truncates (removes all records from) a table.

Hi again,

just relax - bdbpre doesn't alter the table, it just dumps it.
With bdbpost you have to be carefull indeed, make your first steps in demo companies with this tool.
AFAIK bdbpre locks a table while dumping it, so try small tables first if you want to dump tables currently in use. Most often made mistake with bdbpre is ommiting the package combination or specifying a wrong one. There are 3 ways to create outputfiles: the first is what I call "bigdump", meaning that a dump of several tables will be stored in one ascii file (including the data description, which is pretty handy). Second is creating seperate seq. files for each table with a field delimiter.
bdbpre6.1 -t"|" -o/home/mydir -Ntiitm001 -pB40C4cxxx -C222 will create /home/mydir/ttiitm001222.S if the PC for company 222 is B40Cc4xxx.
The third way is quite like the 2nd, but fixed field length is used .... never used that one :-)
Generally: bdbpre can't really do harm, bdbpost was built to populate tables and should only be used after a decent backup (which bdbpre provides :-)

hth

Norbert

I was wondering if a bdb_pre on a table truncates (removes all records from) a table.
Rajesh,
You have to be careful with the options for bdbpre and bdbpost.
$ bdbpre6.2 -U
-E file: Redirects informations to file
-I : File with table names
-K/-k : Backup/Drop table after creating dump
$ bdbpost6.2 -U
-A : Append rows (skip duplicates) or Create new table
-a : Show total of duplicates. This option is only effective in combination with the -A option.
Note that when using this option performance will be decreased.
-K/-k : Backup/Drop existing table
-R : Append rows (replace and show total duplicates) or Create new table

Norwim,

just relax - bdbpre doesn't alter the table, it just dumps it.
Generally: bdbpre can't really do harm, bdbpost was built to populate tables and should only be used after a decent backup (which bdbpre provides :-)
The bdbpre can drop the table after the dump.
The backup option is not supported for all Baan Versions. Here is more info from Baan Support.
MR Reference: 8.5a MR Priority:
Resolution: Comments from development:
The backup function is not supported in Baan 5 and newer. In Baan IV it is supported but for Bisam databases only. It does a simple copy of Bisam files.
For backups you need to use bdbpre binary.
We will remove the backup option from bdbpost usage list in next portingset.

nprao is right -
because I never used the -k option while dumping I didn't realize that bdbpre could ever be dangerous.
Hoping that no damage has been done, I promise to post more carefully in the future.

Nevertheless for me bdbpre and bdbpost are the most important tools in Baan.
Sorry

Norbert

Thanks mates for all the information. I'm dont really have the need for it. But I just simply want to know the unknown or little known. So if all you guys out there want to write and write and write about this topic please keep writing in this post. More so as there is no documentation available for this.

Cheers,
Rajesh.

E.g. the Enterprise 8.4 server - Technical Manual describes these tools.
also in iBaan ERP 5.0c - Tools Technical Manual

Han! Mate can you send me those docs please if they are not licensed by you?? I mean you din have to pay for it seperately..then...I can understand if you wont.

Cheers
Rajesh