maxwell
17th December 2003, 15:48
Can anybody please tell the syntax to do forcefully do reconfiguration of all tables of all company or atleast company-wise? may be how to force bdbreconfig for all tables of a company? or any other better idea?

pconde
17th December 2003, 16:14
Hello,

bdbreconfig reconfigure tables only if it found that there is a differences in the data dictionnaries beween the files d* and the d*.new .

If the two files are the same nothing occurs.

If you want to force a reconfigure:
create sequential files from tables and then reload with session create table from sequential dump with the option drop tables before loading;==> thereafter you need to do the repair of reference counters.

bdittmar
17th December 2003, 17:41
Originally posted by maxwell
Can anybody please tell the syntax to do forcefully do reconfiguration of all tables of all company or atleast company-wise? may be how to force bdbreconfig for all tables of a company? or any other better idea?

If BISAM Tables use enclosed BaaN Guide !

Regards bernd

nick_rogers
17th December 2003, 21:46
Create runtime will force it, convert runtime just does the changes.

maxwell
18th December 2003, 05:15
but I don't thing Create runtime is going to re-align all my data also, say for example if I have changed the alignment,etc of a domain..is there no option in bdbreconfig to forcefully re-configure the data?

Hitesh Shah
18th December 2003, 06:24
Use re-organize tables with data and indices only . Internally it translates the same to bdbreconfig6.1 -Z .

Beware this option extremely timeconsuming. Carefully estimate the time by giving the tables in small range and do the same when nobody is working in the system.

When u change the alignment of data, Baan takes table for reconfiguration by default . When u convert to runtime with reconfig tables option , it automatically reconfig data.

Reconfiguration indicators in Baan are stored in table ttadv501.