DSXchange

This is not the correct forum for this question. This forum is for suggestions about how to improve the DSXchange site/forum. Please post in the correct forum so that, at the very least, we have some inking about what job type you're talking about. This question, for example, has different answers f...

You can use Performance Analysis to determine where the "hot spots" are in a job.

I suspect the strategy in the stage is Replace Existing Rows

Please mark this thread as Resolved

Which machine has the most free resources? In a future version (possibly the next version, which some IBMers are now calling 8.5) something called "dynamic optimization" is introduced, where you design a sort (and some other operations) and a dynamic decision is made by the software about ...

dsjob -run returns its own exit status; if the job request was made successfully then the correct exit status for dsjob is 0.

However, the -jobstatus option has a side effect of causing dsjob -run to exit with the exit status of the job itself.

Do you have the authority to unilaterally change your client's data?

0x80 represents null internally in DataStage. Can you learn what this particular byte is being used for in the troublesome file?

was all you needed.

Before you do that, why not investigate the Performance Analysis and Resource Estimation tools right there in DataStage?

Standard practice here is, when marking a thread as Resolved, to make a post indicating how it was resolved. This helps future searchers. Also, we strive for a professional standard of written English, among other things to help those whose first language is not English. DSXchange is not a mobile t...

You don't. Each Lookup stage allows only one reference input to deliver multiple rows - that's why you choose the link name from a drop down list.

Multiple inputs delivering multiple rows is getting you into Cartesian product territory - you can end up generating very many rows on the output.

Perhaps the RMM stage could be used to good effect here?

Use the ByteLen() function to determine the number of bytes in the string.

Splitting a multi-byte character can leave you with totally meaningless data. Why are you attempting to do this?