Page 1 of 1

Inline sort Storage

Posted: Fri Jun 11, 2010 12:51 am
by myukassign
Hi...

I would like to get clarification about inline sorting. (The sort we apply on the input link of various stages where we have option of stable /unique sort).


Where Datastage temporarily keep this data for inline sorting. Will it store the same place where the sort stage store (scratch disk) or will it store in the engine directory itself.


Please help me.

Posted: Fri Jun 11, 2010 4:33 am
by ray.wurlod
Same as the Sort stage. The tsort operator is used in both cases. It will attempt to do the entire sort in memory until allocated memory is exhausted, then spill to scratchdisk.

Posted: Mon Jun 14, 2010 1:39 am
by myukassign
Thanks ray. That helps.