Hello,

I need to make a change to our item master which will mean the table will require re-configuring. We have 6 Baan companies with populated item masters so this process takes over 24 hours. As it's difficult to find a suitable time to take the Baan system from the business for this long I'm wondering if there is a quicker way. The change I need to make is to add an additional column at the end of the tiitm001 table.

Please let me know if there is any other way to make this change with having to run a re-configure for 24 hours. Our item master is relatively small so I'm sure other people have come across this issue.

Thanks

PJ

rename refint6.1 to refint6.1.real

create a shell script in $BSE/bin called refint6.1

#!/bin/ksh
refint6.1.real -rs "$*"

should be much faster if your item master is as small as you say.
The time must be being spent on refint, which is worthless unless you plan on deleting a lot of texts soon.

also, you can set:
ORA_MAX_ARRAY_FETCH=1000
ORA_MAX_ARRAY_INSERT=1000
RDS_FULL=1000
SSTS_SET_ROWS=1000

in your BW or unix environment before you start.

Dave

Couple of things Dave..
a) Are those commands "ORA_MAX_ARRAY_FETCH=1000" etc entered in the Command field of a BW Configuration?

b) Are the above mentioned commands Oracle based? If so, then any idea whats the equivalent ones for SQL Server?

Appreciate your input on this..

sk

The following idea from me is not tested and maybe pure Baan fans will reject ist, but it would most likely work:

a) perform your change on the test system (here runtime should not matter)
b) note the difference in the created dict file
c) note the difference in the created table
d) perform the change on the life system, but do not peform CRDD
e) manually change the dict file in vi/notepad
f) manually change the table in oracle: alter table add collumn ...
g) delete the runtime indicator in the corresponding tools table.

Finished.

Sound hacky? It is, but I think it is also feasable.

Regards

Markus

Hi Markus,

although I like 'hacky' tricks, there is one flaw with the proceeding you suggested.
I haven't got access to a Baan system atm, so I don't know the table name, but there is a tools table which specifies the tables columns. You would have to add the new column here with ttaad4100, or the next CRDD (maybe run in far future) will lead to serious confusion.
But generally your idea sounds pretty good to me.

regards

Norbert

Actually my idea is to do the normal customzation within Baan, but not the CRDD. This way the required ttadv table will have all entries.

Wether it works is something different.

Thanks for all of your comments.

I'm starting to get 'cold feet' and thinking that I'm best sticking to the tools provided to avoid getting in to a real mess if things go wrong.

Cheers

PJ

Couple of things Dave..
a) Are those commands "ORA_MAX_ARRAY_FETCH=1000" etc entered in the Command field of a BW Configuration?

b) Are the above mentioned commands Oracle based? If so, then any idea whats the equivalent ones for SQL Server?

Appreciate your input on this..

sk

Yeah, my solution was for unix and oracle..

I'd check the SQL drive manual for equivilant commands, but in my experience they're not needed.

Dave

The following idea from me is not tested and maybe pure Baan fans will reject ist, but it would most likely work:

a) perform your change on the test system (here runtime should not matter)
b) note the difference in the created dict file
c) note the difference in the created table
d) perform the change on the life system, but do not peform CRDD
e) manually change the dict file in vi/notepad
f) manually change the table in oracle: alter table add collumn ...
g) delete the runtime indicator in the corresponding tools table.

Finished.

Sound hacky? It is, but I think it is also feasable.

Regards

Markus

That's essentitally what NPRao will refer to as "The Boeing Method".
Just skip d and e and use internal export / import and you're fine.

Also - that's what Baan 5 and LN do automatically.

Dave

Thanks for all of your comments.

I'm starting to get 'cold feet' and thinking that I'm best sticking to the tools provided to avoid getting in to a real mess if things go wrong.

Cheers

PJ

You can at least use the ORA_MAX_ARRAY= stuff i mentioned, those are just environment variables for processing large amounts of data.

Also, if you choose "repair references to parent only" (if that option is available for you on the convert/create screen.) it will be the same as my script.

Dave

Bit the bullet in the end and I have now got this process down to 2 hours (10 tables) instead of the 36 hours it used to take.

Made the table change in Baan, CRDD without re-org.This gave me a *.new table def file. Removed record from ttadv501. Altered the table in Oracle and copied the 'new' table def file to replace the existing one.

More or less what you guys suggested.

The only thing now is that my overtime for doing this type of change is dramatically reduced!!