clarification on APT_TSORT_STRESS_BLOCKSIZE

Akumar1 · Post by **Akumar1** » Fri Aug 13, 2010 8:18 am

Hi All,

APT_TSORT_STRESS_BLOCKSIZE environment variable can be used only when you have a sort stage used in your job design with restrict memory option selected.

Is this right?

Thank you very much in adv for your reply on this.

Regards,
A kumar

kumar_s · Post by **kumar_s** » Fri Aug 13, 2010 8:34 am

This Environmental variable is used to restrict the Physical memory usage of Tsort operator. Given in MB.
Beyond which, data will be written into scratch disk.
Not just Sort stage, but inline sort will also be affected by this Variable.

Akumar1 · Post by **Akumar1** » Fri Aug 13, 2010 8:55 am

I am not a premium member

kumar_s · Post by **kumar_s** » Fri Aug 13, 2010 8:58 am

Pls try to aquire the membership, as it will be helpfull for you as well as for the forum.

ray.wurlod · Post by **ray.wurlod** » Sun Aug 15, 2010 3:02 am

Akumar1 wrote:Hi All,

APT_TSORT_STRESS_BLOCKSIZE environment variable can be used only when you have a sort stage used in your job design with restrict memory option selected.

Is this right?

Thank you very much in adv for your reply on this.

Regards,
A kumar

This is not right.

APT_TSORT_STRESS_BLOCKSIZE affects all three kinds of sort.

DSXchange

clarification on APT_TSORT_STRESS_BLOCKSIZE

clarification on APT_TSORT_STRESS_BLOCKSIZE

Re: calrification on APT_TSORT_STRESS_BLOCKSIZE