DSXchange

Your user-defined SQL is generating a large number of messages.

Try it independently of DataStage, for example using sqlplus. What happens then?

RT_CONFIG62 is a hashed file containing configuration data about the job. You could try re-compiling the job. First, however, check that RT_CONFIG62 is not corrupted, using the UVFIXFILE RT_CONFIG62 command from the Administrator client Command window.

Don't attempt to do what Oracle forbids.

Is this the case for ALL parallel jobs, or just this one? What's the design of this one?

Talk to your vendor. They can typically do a reasonable price for the licensing on the stand-by machine. IBM can also provide (chargeable) advice in implementing a high-availability solution. However, if disaster recovery in your scenario simply means the ability to run on server B if server A fails...

Thank you for following through and letting us know. Turns out it was security rather than firewall.

Query the DS_AUDIT table to determine when the job design was most recently changed, and by whom. Do you have an export of the job?

You're confused and you're making us confused. What precisely do you mean by "not able to run parallel jobs"? Can you compile parallel jobs? What happens when you try to run a parallel job? Is anything logged? Does any message appear anywhere else, such as in the &PH& directory?

Take a look at hamzaqk's signature block: probably regards MySQL as a toy.

Gotcha there! The membership directory is also called Ray.

GET RID of the sqlcode column from the sequential file and transformer stages.

Welcome aboard.

This is not behaviour I have seen in more than 12 years working with DataStage. Can you give a specific example?

And it might be set to "" or even unset in the project's own environment (via the Administrator client perhaps).

Use an upstream Sort stage that generates a Key Change column, and use the key change column in the Transformer stage's constraint expression.

But why not use Remove Duplicates stage?

I manage it (without needing to be crazy), primarily with a bit of forethought. Yes, quite complex job designs. Though I also prefer to opt for modularity rather than complexity.