information integrator & informix

hello all! has anyone tried connecting Info integrator to Informix 9.x? if so, here are my questions....how much of the server's resources does it use? does it matter if using Info integrator pointing to a replicated instance versus the production instance? We use HDR on Informix and want the Info integrator to point to the HDR instance, not the main production instance.. Thanks Tom

I don't think that II to a HDR secondary would be too successful. Basically II is a combination of synonyms and gateway. The query is made on the II server against a 'nickname' which is fundamentally an expansion of the IDS synonym. When queries are made on the nickname, depending on the query, the II server might need to push data to the remote server (temp table) and then join against that table. So there might be some logging occuring. As far as impact - the backend server treats the II query much as any remote query. So there isn't really any impact on the BE - or at least any more than a normal distributed query. M.P. "tomL" <tomcaml@yahoo.com> wrote in message news:3158a6a2.0310211335.74b999cf@posting.google.com... > hello all! > has anyone tried connecting Info integrator to Informix 9.x? > if so, here are my questions....how much of the server's resources > does it use? > does it matter if using Info integrator pointing to a replicated > instance versus the production instance? We use HDR on Informix and > want the Info integrator to point to the HDR instance, not the main > production instance.. > > > > Thanks > Tom