DSXchange

Interview questions are sometimes designed to determine how thorough your knowledge is. For example "name the eight days in the week".

You can do it in stage variables if you don't need to do a routine.

The Oconv on the time may require "MTS" as its second argument (rather than "MT") if the database requires seconds in its timestamp format.

There should never be any reason to kill DataStage processes. Do you even understand what these particular processes are? To avoid killing these, make sure that the DataStage deadlock daemon is running, and educate users to close DataStage clients correctly. How do you think society would work if yo...

That's because you are re-opening the file (and thus positioning to beginning of file) within the loop. Open the file before you start the loop and don't forget to close the file (which releases the lock that OpenSeq sets) after the loop and before returning. You could use a Pivot stage (with some u...

Do the same thing with scratch disk that you have done with disk.

Using only one directory for scratch space across all four nodes introduces a bottleneck. Use four (or more) and the same "round robin" mechanism for allocating them. Make sure you have plenty of free space for scratch.

It is possible (with small probability and depending on your data) that any partitioning algorithm except round robin will have a sufficiently skewed distribution of rows over nodes that a node gets no rows. Also check that the stage in question is not constrained to executed in a node pool (a subse...

Show us some values, including one for R.

Also please advise what data types are involved.

Wrong. The job executables are suitable only to run on AIX.

Take a look in the log. Is there actually an entry in there stating what you claim, that the job aborted because of exceeding a warnings limit? If so, can you please post the text of that log entry? Can you also try running the job from Director, rather than from Designer? Also look in the Director ...

Best resolution is to re-compile everything on the UAT system, the operating system of which is apparently not in the IBMrios class.

Have you searched through this forum? It HAS been discussed.

What has changed between yesterday and today?

Clearly something has.

Take some time to cogitate about what kinds of things can cause "cannot find file" errors.

This is an Oracle configuration. You need to sweet-talk your DBA into increasing the number of connections, and you'd better have some pretty convincing reasons.

... once you've determined what it is that you DO want (see my earlier post).

Would you mind asking them?