Hi

I have BaanIVc4 (sch1) in an AIX platform (IBM Risc/6000 F40).
I have some tables in Oracle 7.3, and the others in Bisam.

I need upgrade the machine because they have 8 years and has discontinued.

Someone knows if Baan have problems in an Linux platform?

Regards
Paiva Barbosa

Not answering your question directly ... but surprised to see that you have some tables in Oracle and other tables in BISAM.

Baan does not / cannot support two databases at the same time. In a single transaction, if the transaction spans across two database drivers, then if any retry happens, Baan cannot handle. As long as the tables involved in a transaction is handled within single database driver, it should not be a problem.

So, please ensure that the tables residing in Oracle and tables residing in BISAM are not inter-dependent.

smanohar

We have all company specific data in oracle tables but be have "tools" tables in bisam. (not sure of why this was chosen)

Terry

Hi Terry,

We have similar set-up. BaaN advised us to do so when we had performance issues with tools sessions.

Since BISAM is basically a flat file, there is no database transaction involved. It would be much faster rather than going to RDBMS and fetching the data.

But splitting the application data and tools data into different databases is acceptable, because on the top of my head I couldn't think of any dependencies between them.

Hi pbarbosa,

may I direct you to the thread 'who is using linux proting set' in the poll thread? We just switched to linux with remarkable success.
Whether you have to stick to oracle simply depends on the size of your tables. Although the 2G border doesn't exist any more on OS side, tbase still can't handle data files (.bdt) larger than 2G. We are using tbase here, but as far as I know, oracle is supported under linux. I strongly encourage you to download the linux porting set from SSA support site and do a test conversion. Feel free to ask me questions ...

regards

Norbert

Is there an official Linux porting set ?

Yup. There is official Linux Porting set, which you can download from the Support website.

Not answering your question directly ... but surprised to see that you have some tables in Oracle and other tables in BISAM.

Baan does not / cannot support two databases at the same time. In a single transaction, if the transaction spans across two database drivers, then if any retry happens, Baan cannot handle. As long as the tables involved in a transaction is handled within single database driver, it should not be a problem.

So, please ensure that the tables residing in Oracle and tables residing in BISAM are not inter-dependent.

I have many tables in Oracle (tiitm001 for example) because i have integrations with another application (when a item is created , he is copying for another app for the oracle triggers). In session ttaad4110m000 i have 2 BD ( Bisam and Oracle) and in ttaad4111m000 i have some tables defined "ORACLE" and all the others defined "AUDIT"