Tshort operator

prasson_ibm · Post by **prasson_ibm** » Mon Jul 20, 2009 11:45 am

Hi,
i have a job in which i m using join stage,and source of the join stages are one dataset and one db2 api.Here i m performing inner join basced on key column.
On the dataset link i have used same partitioning and on db2 link i have used hash.Job is running fine,but i m getting worning in log about Tshort operator.so can anyone help me to handle that warning??

and can anyone tell me what is the meaning on prpogate,clear and set options in advance tab..??

chulett · Post by **chulett** » Mon Jul 20, 2009 1:12 pm

Post your complete, unedited warning. For the last question, press the 'Help' button in the stage, they are explained there.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 20, 2009 4:20 pm

I think tshort is the toothless version of the tsort operator.

DataStage is inserting tsort operators (and alerting you to the fact that it's doing so) because sorting is required on the input links to the Join stage and your design does not provide explicit sorting on those links (so DataStage assumes the data to be unsorted).

You can prevent this behaviour by adding Sort stages on the links, even if their sort mode is "don't sort, already sorted".