DSXchange

I wonder what R0 could be? Can someone who knows their way around take a look at such a record in DS_JOBOBJECTS and post their findings? (I don't have access to DataStage at the moment.)

Not without seeing the actual job design.

The key lookup failed because the key did not exist on the reference input link. The job aborted because you had set the "lookup failed" rule to FAIL. By setting it to CONTINUE you allow the job to continue to run; any columns mapped from the reference input link will contain NULL (it becomes effect...

Libraries are definitely a problem. DataStage is a 32-bit application (except on Itanium) so you need to ensure that the shared library search path that DataStage uses (set up in the dsenv script) has the Oracle 32-bit library directory ahead of the Oracle 64-bit library directory.

So??? Maybe this site will help. I wonder if IBM would allow it as an alternate certification exam?

Not all stage types in parallel jobs support maintenance of performance statistics in Designer. This is particularly true of some of the debugging stages.

That is true of almost all passive stages in parallel jobs. You need to adopt a different mind set from your server job design skills. Parallel jobs do not accept this "blocking" strategy (so that fastest possible throughput can be obtained, without causing dataflow deadlocks and permitting of re-pa...

There are five environment variables that can affect the efficiency with which fixed width records can be propagated between player processes; these are the so-called "transport block" variables. Read about them in the Parallel Job Advanced Developer's Guide, Chapter 6.

Simply looking in the job log will reveal the error most of the time. Resetting the job will retrieve the error information most of the rest of the time.

Why not use the API?

Everything you need to know is here. main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel Dset_TEDSZ06002JB_00001. The number of partitions is constrained to 1, but the eSame input file, /work/EDWCST/WHSE/working/ds_TEDSZ06002JB_00001.d...

Where's the challenge in that??? Even if the pass mark were 75/79 that ought not to prevent you from attempting the test. You should be aiming at scoring 100%.

What kind of trigger(s) do you have on the Execute Command activity? Do you have any other form of error handling, such as "automatically handle activities that fail" or an Exception Handler?

A Sequencer can only perform one task; triggering either when Any or All if its inputs have fired.

The term you need here is Job Sequence. Or perhaps Sequence. Not Sequencer.

Lookup File Set is accessed from disk. Only its index is loaded into memory, as far as I am aware.