DSXchange

Without a reject link (which is what you originally asked about) your final WHERE condition needs to contain the logical inverse of the combination of all your other WHERE conditions. For example column <> value1 AND column <> value2 AND column <> value3...

What is your disposal of the rows? That is, what is the update method you are specifying in the target stage?

Even so, by identifying which ones are taking longer you can still narrow the scope of your investigation, because it has to be something that they are doing - or, perhaps, something that HAS changed (perhaps not something in DataStage). For example someone may have added more indexes to the databas...

The Schedule view in Director remains only a GUI that queues entries for either cron or at (depending on whether it's a repeating or one-off schedule).

There is no such thing as a DataStage scheduler.

Not necessarily. But it will be no slower. Provided that the inputs are in an "always ready" state.

The simplest model is where there is no operator combination. Each operator (for simplicity) represents one stage. You have three stages, therefore three operators, on each of three processing nodes. That makes for a total of nine "player" processes executing the operators. Each processing node has ...

The complete set, if you please. The message suggests that you have nominated link number 11 somewhere (numbering starts from 0). We need to determine whether that is the case. You can post the relevant section of the generated OSH if you prefer. As for a rejects link, draw an additional output link...

Define performance. Round robin can be faster than sort/merge but, if you lose the required sorted order of your data, what is the value of that? You have a wrong answer, faster.

Had you visited the web site whose URL I provided you would have found an announcement there that, from July 2nd, 2007, IBM certification tests would only be delivered through Prometric.

Can't get much more definitive than that.

Please post your complete set of WHERE specifications from your Filter stage. Without them it is impossible to advise.

Let's say you're processing dates in a Transformer stage. Use the following commands in ExecTCL as before-stage and after-stage subroutines. Before-stage: SET.LOCALE TIME FR-FRENCH After-stage: RESTORE.LOCALE This will mean that, irrespective of what the rest of the job is doing, the Transformer sta...

Look at the execution times of the individual activities (jobs, routines, commands) that the sequence runs. Monitor these over time or, if you still have the log entries, find out which of them is taking longer. Use that knowledge to target your investigation more precisely. Right now your question ...

DataStage certification, like most IBM certifications, is managed world-wide through Prometric - it is with them that you organize a time to take the test and is to them that you pay the money. You can find more information about the test itself, including test objectives, ten sample questions and r...

You have more digits than are required (that is, your string includes fractional seconds, but your date format string does not).

There's no convenient way from the Repository, because the collection of parameter properties is nested within the job definition record and, as well, because there are two sets of default values - design-time defaults set in Designer and run-time defaults set in Director. You're probably best to cr...