User inserted tsort missing in job score

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
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

User inserted tsort missing in job score

Post by zulfi123786 »

Hi,

I have inserted link sort over field "ENROLLEE_ID" in a job and I can find it in Generated OSH code but the tsort operator does not exist in the job score why appears confusing to me. Operator combination is disable still cant find the sort operator, should it not exist in the score ?

OSH CODE -

Code: Select all

#### STAGE: jn_MbrCov.ToJoinMemCovKey_Sort
## Operator
tsort -key ENROLLEE_ID -cs -asc -key UPDATE_DATE -desc -nulls last -nonStable
## General options
[ident('jn_MbrCov.ToJoinMemCovKey_Sort')]
## Inputs
0< [] 'Xfrm_mbrcov:ToJoinMemCovKey_Part.v'
## Outputs
0> [] 'Xfrm_mbrcov:ToJoinMemCovKey_Part_Sort.v' ; 
From Job Score that have the field mentioned

Code: Select all

ds13: {op9[4p] (parallel APT_TransformOperatorImplV114S1_NHI00_IHCISIPConfinementDetail_Ext_Xfrm_mbrcov in Xfrm_mbrcov)
      eOther(APT_HashPartitioner { key={ value=ENROLLEE_ID, 
        subArgs={ cs }
      }

ds29: {op22[4p] (parallel APT_TransformOperatorImplV0S61_NHI00_IHCISIPConfinementDetail_Ext_lkp_DRG_KEY in lkp_DRG_KEY)
      eOther(APT_HashPartitioner { key={ value=ENROLLEE_ID, 
        subArgs={ cs }
      }
The field is used in both sorting and partitioning, as I can see it in the Partitioner, is the sort operator fused with the partitioner ?
- Zulfi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How about you show us that part of the score that relates to the jn_MbrCov.ToJoinMemCovKey_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.
Post Reply