Difference between external sort and inline sort

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
Manu1
Participant
Posts: 36
Joined: Mon Aug 31, 2009 5:51 am
Location: Hyderabad

Difference between external sort and inline sort

Post by Manu1 »

Hi,
Could any one explain me the the difference between external sort and inline sort apart from external sort stage has more options?

I am trying to understand how they differ in terms of creation of OSH,usage of scratch disk and performance impact (If there are any more please mention them as well).
Manu
Datastage Devoloper
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you be more specific about what you mean by these terms? For example there's no such thing as an "external sort stage".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Manu1
Participant
Posts: 36
Joined: Mon Aug 31, 2009 5:51 am
Location: Hyderabad

Post by Manu1 »

ray.wurlod wrote:Can you be more specific about what you mean by these terms? For example there's no such thing as an "external sort stage". ...
external sort stage is the sort stage.
Manu
Datastage Devoloper
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Re: Difference between external sort and inline sort

Post by zulfi123786 »

In terms of orchestrate and scratch disk they are the same as they end up with the same tsort operator.
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

I would also be curious to know the answer to this.
Regards
Sreeni
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The difference is that you have quite a few more options with the explicit sort stage as opposed to the implicit sort stage; they call up the same sort by default.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

All three sorts (Sort stage, input link sort and inserted sort) cause a tsort operator to be included in the score. All three are governed by environment variables such as APT_TSORT_STRESS_BLOCKSIZE, obviously, because all three use the tsort operator.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

They all use the same tsort operator, from what I understand.

<wink>
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply