DSXchange

Remote execution is only for execution on USS (Unix on mainframe). View what's on the Remote tab, then disable it. Only DB2 is visible because only DB2 (of those databases) is supported on zSeries machines.

They are available as "e-Learning" from IBM (in exchange for payment, of course). Contact your local IBM Learning Center.

Assuming you have the drivers, DSNs are created by editing the .odbcini file (which is referred to also as $ODBCINI environment variable). In any project create an entry in uvodbc.config to enable that DSN's use from that project.

Before I provide a greater level of detailed feedback, have you tested all of these commands in version 8 parallel environment? If so please provide detail concerning your test cases, expected and actual results. If not, please say so so that people will understand that this is purely a theoretical ...

I still fail to see the relevance to QualityStage or, for that matter, to U (one of our occasional posters).

The second person personal pronoun in English is spelled "you", not "u".

In the Job Run Options dialog, set Limits on the Limits tab.
In Director, change the defaults via Tools > Options, which a Search would have discovered.

Even better, design jobs that don't generate warnings in the first place.

DBMSCODE is a link variable that returns any code returned from the database server. It is most useful in a derivation on a reject-handling link to pick up the reason that a row was rejected by the database on the non-reject output link from the Transformer stage.

Click on Help in each screen, where they are fully explained. Come back if there's anything there that you don't understand.

There's nothing in QualityStage that requires the use of these. But you have posted in the QualityStage forum.

I accept that DataStage and QualityStage shared the same Designer in version 8, but QualityStage does not perform lookups using the stage types you have nominated.

SQL order by will slower down the job performance. As DS Sort is much faster. It is very dangerous to make completely general assertions like that. A database sort assisted by a B-tree index will outpace anything DataStage can do, because the index is stored in already-sorted order. All the "sort" ...

That's because you did not set NLS_LANG in your changes. You set LANG, but not NLS_LANG.

The dsrecords command is available on all platforms. It has an undocumeted -n option for returning just the number (not the "records" word).

Why not run both designs through the Resource Estimation tool?

Why not monitor the FTP server and find out?

My guess - and it's only a guess - would be parallel simultaneous connections.