DSXchange

Director client status view?

Please check that APT_ORCHHOME and LD_LIBRARY_PATH (or LIBPATH or SHLIB_PATH) environment variables are also correctly set.

Search DSXchange for a parallel equivalent of the server routine Ereplace. It's exactly what you need.

Assuming Target1 and Target2 are Data Sets (and, if not, why not?), would it be possible to sort data on their way in to the Data Sets?

How and where in the design are your data partitioned?

That is correct. Deployment packages (which is what Information Server Manager (istool)) deals with, are different from DataStage export files.

Command line choices for importing from dsx files do exist, including dsjob, dscmdimport and dsimport.

Welcome aboard. Best practice is to become fully aware of all of the data quality issues, probably using a profiling tool such as Information Analyzer. Apply this regularly, for example quarterly, because data quality always degrades. Once your profiling effort has been done you will have establishe...

Not really. You can refresh the data that the reports ultimately use, but then you would need to initiate any internal Busines Objects reformatting via a command line. That command can be run from DataStage, but DataStage has no control over what the command does (though it can capture the output an...

Please disable operator combination so that you can know which stage is throwing the error.

Have you tried doing the import from the command line? It may generate "better" error output.

Welcome aboard.

May I recommend that you take the IBM training class "DataStage Essentials" at an early opportunity?

You don't login to DataStage from the UNIX environment - you login from one of the DataStage clients in a Windows environment.

Yes. The results of the query must be sent back.

If the data are already sorted, use a Sort stage to specify "don't sort (already sorted)".