Page 1 of 1
clarification on APT_TSORT_STRESS_BLOCKSIZE
Posted: Fri Aug 13, 2010 8:18 am
by Akumar1
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
Posted: Fri Aug 13, 2010 8:34 am
by kumar_s
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.
Posted: Fri Aug 13, 2010 8:55 am
by Akumar1
I am not a premium member
Posted: Fri Aug 13, 2010 8:58 am
by kumar_s
Pls try to aquire the membership, as it will be helpfull for you as well as for the forum.
Re: calrification on APT_TSORT_STRESS_BLOCKSIZE
Posted: Sun Aug 15, 2010 3:02 am
by ray.wurlod
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.