Re: Informix with DB2's DataJoiner

In article <36F86EAE.228CDB4@notes.heb.com>, "Cheryl L. Kendricks" <kcheryl@notes.heb.com> wrote: > Will DataJoiner work with Informix 5.X. If not then has anyone worked > around this issue (found another way for these two to communicate?). > Also if you have worked with Informix and DataJoiner, I be interested in > hearing your opinion on it's performance and manageability. Please reply > directly to my email address > > TIA > Cheryl L. Kendricks > Database Analyst > H.E. Butt Grocery Co, > San Antonio TX > kcheryl@notes.heb.com > Hi, I'm working with DataJoiner AIX V2.1 and Informix 7.2 quite a while. At least there is a Data Access Module for Informix 5. We made the following performance Measurements (We use only Replication and so we only tests simple INSERT, UPDATE, DELTETE, SELECT on one table without Joins etc.): Local SELECT/INSERT/UPDATE upto 2,5 times slower den native Informix. Remote SELECT/INSERT/UPDATE though one remote DataJoiner upto 2,5 slower then native Informix. Remote SELECT/INSERT/UPDATE through two DataJoiner upto 2 times quicker! den native Informix. We use it for replication issues only (DB2/390 <-> Informix AIX). It is very stable. Informix E/SQL was a little bit buggy - so we must use 7.24UC6. Ciao Matthias ---- stemmler@secco.de -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own