RE: ETL tool configuration
Dont forget to tune $INFORMIXDIR/etc/plconfig.std. After I tuned, got 400% improvement on fragmented tables.
-----Original Message-----
From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com]
Sent: Friday, April 07, 2000 6:27 PM
To: Farmer.Byrd@cfwy.com; informix-list@iiug.org
Subject: Re: ETL tool configuration
From: "Farmer, Byrd G - CFC" <Farmer.Byrd@cfwy.com>
>
>We are using Informatica as out ETL tool to load data into the warehouse.
Sucker! :-)
>The Informix engine is 7.24 UC3. We are only getting 25-30 rows a second
>processing through Informatica. Theire tech support was here yesterday and
>said that the write preformance in Informix was too low. However I can
>load
>10,000 rows a second using HPL, so I am not sure they are right. Does
>anyone out there have any suggestions on what parameters I might try to
>improve the speed of the Informatica load? We are in the process of trying
>to upgrade Informatica from 4.14 to 4.60 now and this would be a good time
>to make any changes to the engine. Thanks for any help you can give.
How about you post us your onconfig, onstat -d and onstat -D?
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com