Re: from SE to Online: Experience??

zondag (zondag@xs1.xs4all.nl) wrote: : The company I work for considers moving from Informix Standard Engine to : Informix Online. : Reason: increasing complexity of database, need to effectively use the : multiprocessing capabilities of our hardware. : Anybody out there with experience in moving from SE to Online? : Is it easy? Difficult? In what respect? : What pitfalls or challenges are there in the installation and conversion : process? Which changes to expect in daily operations, and which during : development stages of our software? : Brief system outline: : unix S5V4 system, hardware scalable up to 6 processors; : using Informix C-ISAM, SE, ISQL, 4GL; : software written in C (using C-ISAM) and 4GL. : application divided into OLTP-part (with random read/updates) and batch part : (with mostly serial updates). : (we suppose we have to replace our C/C-ISAM calls by ESQL/C calls. any : alternatives?) The course notes for developing informix database applications use to talk about differences between the two. There are a couple of syntax that is different between the two. Such as "START DATABASE" statement, only for SE, also only SE have audit trails, OnLine uses Logical Log files. Administration is totally different for the two engines too. Defaults are also different for the two engines, such as row/page level locking, isolation level. These will affect your application directly. However, on the whole, porting over shouldn't be two tedious. The data itself will probably port over cleanly. What is important is the application itself. Try to get some testing done before the actually switching over to avoid surprises. Calvin NG