DSXchange

Your DataStage Designer only brings across a couple hundred rows of data in any view data statement. Your problem is the duration of the SQL select itself. It could be your SQL is not properly tuned, or you are missing database indexes, or your SQL statement is too complex and some tables need to be...

You might be able to do something with XML export files. A standard job export file in XML format is not that readable, but if you run it through an XSL stylesheet you can create readable job documentation. DataStage delivers an example file, DSJobReport.xsl, into your DataStage directory. If you ex...

In SQL Server an identity column automatically generates sequence numbers when rows are inserted. In normal operation you leave it out of the insert column list so that SQL Server sets it. If you are doing data conversion you may want to explicitely set this value, for example you want to retain the...

Round robin is the fastest partition method because there is no intelligence to the partitioning, it is merely passing it around. I think this is the default partitioning method. There are some stages that require a specific type of partitioning in order to work correctly. For example the aggregatio...

Firstly auto complete and the add column box both show the columns in alphabetic order. Secondly the order of columns is irrelevent for what you are trying to do, what you need to focus on is the order of your stage variables. Stage Variable values are derived in order from top to bottom.

I've got the same problem on my Windows XP machine using version 7.5.1. As soon as I delete a stage CPU usage ramps up to 100% and stays there for any action I try to take in the job. I am logging in as a normal domain user, the only fix I have been able to come up with is to run the Designer as a d...

And to address your original requirement you can get a list of all jobs in a project by logging into the DataStage server and running the command:
dsjob -ljobs <project>

Make sure you have the Multiple instance check box checked in job properties. Instead of calling the standard job name ProcessBigAssFile you call it with an instance id ProcessBigAssFile.one and ProcessBigAssFile.two . You can name these instance suffixes anything you want but it is good to choose a...

You do not need a C compiler. The main prerequisites are the components that let your jobs run as web services such as .Net. Most of these come with the operating system or are on the Ascential install CD.

I thought you only needed the C compiler for parallel jobs. Do you also need it to SOA enable server jobs?

There will be new releases of PeopleSoft EPM until 2006 at which point it is likely to move into support only through to 2013, so the DataStage PeopleSoft agreement will stay in place for existing PeopleSoft EPM customers for a long time. The successor product suite, Project Fusion, will replace bot...

Do you have trace level in DataStage set to 0? Compare the QualityStage log files for each job run. It should give you a timestamp for each step in your QS job. Compare the timestamps from your QS run to your DS run to help narrow down what part of the job is slower.

You cannot create an environment variable from Designer. The "Add Environment Variable..." button on the Parameters tab of job properties is really there to link an environment variable to a job parameter. Thus the name is a bit misleading. When you click the add button what you see is a list of pro...

What if you are joining to a dataset? Let's say you join to the same database table in two different job. It then makes sense to dump the table to a partitioned dataset and join to it in the job. Will DataStage accept that the data is already partitioned and sorted and written to disk when each job ...

I would like to use it but at the moment we are trying to clean up some problems on our DataStage installation and don't have the time to also get MetaStage working. There are also problems with working out where the listener and repository will go as we have AIX servers and it seems to prefer Windo...