Link collector works very slow

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
mosheh
Participant
Posts: 9
Joined: Sat Jul 05, 2008 9:16 am
Location: Sandbox

Link collector works very slow

Post by mosheh »

Hi
I'm dealing with a strange problem:
All jobs with link collector work very slow.
I changed the source and target to files and DB and got the same result.
I'm using Round-Robin collection.
To pass the link collector' I'm writing to files and then concatenate them in a command.
Is there any change in configuration or better way to deal with that?
Moshe H.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Round Robin should be the fastest mechanism. Perhaps you could increase your inter-process row buffer size.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mosheh
Participant
Posts: 9
Joined: Sat Jul 05, 2008 9:16 am
Location: Sandbox

Post by mosheh »

Thanks Ray.
Tried that already.
Anything else I can do?
Moshe H.
Post Reply