Inline sort Storage

[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.

[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.

[myukassign]

Thanks ray. That helps.