We have a requirement where we would like to add couple of fields to tdinv700 and tipcs700 tables. We have multiple companies in the production package combination and due to large table sizes, we would like to control where the temporary R files are created. In order to do that we will need to do the bdbreconfig from command line rather than using ttadv5215m000 session.

I have been playing around with this command in our development VRC/package combination and although it will look like that the reconfig has happened with row counter and index creation messages, but when we go back and look into Baan, the table has not changed and nor the reconfigure change indicators in table ttadv501 - 504 has cleared. During the reconfig I also checked to make sure that the R file did get created.

Has any one else any experience with running bdbreconfig6.1 through command line?

Here is the command that I am using.

bdbreconfig6.1 -Ntdinv700 -t/baan_export/invtrans -e/baan_export/invtrans/table.err -i -pB40Cc4d0 -n -m -f -R -C010

Hi shaboo,

did you try to simply set the BSE_TMP variable, before starting the session?

This should tell the bdbreconfig, where to put the file.

Regards

Markus

Thanks Markus,

This is a viable option but we did not have a good comfort level using this variable. We will for sure look further into it.

We have a requirement where we would like to add couple of fields to tdinv700 and tipcs700 tables. We have multiple companies in the production package combination and due to large table sizes, we would like to control where the temporary R files are created. In order to do that we will need to do the bdbreconfig from command line rather than using ttadv5215m000 session.

I have been playing around with this command in our development VRC/package combination and although it will look like that the reconfig has happened with row counter and index creation messages, but when we go back and look into Baan, the table has not changed and nor the reconfigure change indicators in table ttadv501 - 504 has cleared. During the reconfig I also checked to make sure that the R file did get created.



Markus is right, setting BSE_TMP will move the R file.

Aside from that that - bdbreconfig doesn't clear the reconfig indicators, or move the DD.new file into place (it also doesn't create a DD.new btw) the CRDD session does all of that.

So to use bdbreconfig from command line you need to:
1. Generate a <table>.new file in your Package Combination directory
2. run bdbreconfig .... (your command line looks ok)
3. mv <table> <table>.old; mv <table>.new <table>
4. clean out ttadv501-503

Only safe way to generate a <table>.new is via baan. run CRDD Without the reconfigure option checked.

But since you're there already, just set BSE_TMP and make your life easier.

Dave