buffer size

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

buffer size

Post by samsuf2002 »

How can we increase the buffer size in the stages like lookup , TX ,CDC

any suggestion will be helpful
hi sam here
meena
Participant
Posts: 430
Joined: Tue Sep 13, 2005 12:17 pm

Re: buffer size

Post by meena »

Hi,
I am not sure what these stages stands for.
TX=transformer.
CDC=change data capture
But the buffering size can be increased by the environment variable "APT_BUFFERING_POLICY" Or you can increase the buffer size in stage editors, input/ouput page in Advanced tab.

samsuf2002 wrote:How can we increase the buffer size in the stages like lookup , TX ,CDC

any suggestion will be helpful
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Be very consistent. For example, only ever change buffer sizes on input links. Remember that larger buffers means more memory demand; if you are already limited for memory, increasing buffer sizes is contraindicated. What do you believe increasing buffer sizes (in isolation) will accomplish?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply