DSXchange

Thanks for your reply. I have taken a look at section 14 and unfortunately as you mentioned there is very little. When running in parrallel I noticed I can, for example load 2Million + rows in 2-5 seconds, however, the commit takes half an hour in commit time(or something?) and really slows down th...

I am running a job that reads a sequential file, goes through a transform stage and updates or inserts rows to an informix database. The performance using 4 cpus is great until the job closes. It appears that it is doing the commit of all the transactions at the end and taking a performance hit. I ...

I am running a job that reads a sequential file, goes through a transform stage and updates or inserts rows to an informix database. The performance using 4 cpus is great until the job closes. It appears that it is doing the commit of all the transactions at the end and taking a performance hit. I w...