DSXchange

Using the appropriate functions in a Modify stage or a Transformer stage.

What is different between the two servers? "Nothing" is not the correct answer.

It's not possible. DataStage does not control what process is executed by which CPU - it just starts processes. You can see how much CPU was eaten by each process in the Director (Monitor), but not on which CPU.

Welcome aboard.

The simple answer is yes: run it in a separate job, the two jobs controlled by a job sequence.

There ought to be no need to.

That way lies madness.

You'll want to increase it towards infinity, then you'll complain that your jobs don't reach a running state.

Reduce the load on your machine(s) so that jobs can start within 60 seconds.

I did, years ago. Search the forum.

Yes. All you need is the additional authorization code.

Your configuration file is still not right. Did you change every fastname to the node name Sumesh? And it that in fact the name by which the machine is known on the network? It might help if you were to post your configuration file default.apt

Your source is Oracle. Oracle plays by its own rules. Search the forum - you are not the first to have encountered this.

dsdlockd probably cleaned up for you.

Are you running on Windows XP sp2 and, if so, do you have the xpsp2 patch for DataStage client installed?

To where? They are already XML-format exports. You can emplace them in the Templates folder on any client.

Are you sure that the recompile was successful?

Save the changed sequence as a different name, and tell us whether that tries to execute the removed activity.

Import the hashed file's table definition and inspect that. Scroll to the right in the Columns grid and find three extra columns, one of which is location. Any field whose location is 0 is a key column, any field whose location is non-zero is not a key. Navigation within a hashed file record is base...

Did you bother to Search the forum?