DSXchange

Ensure you meet the requirements of this link:

http://www-1.ibm.com/support/docview.ws ... wg27008923

AIX includes features that allow systems to be logically partitioned. If you are running in a partition, versus the entire system, ensure that the partition is giving you enough resources (CPU, memory, etc). A partition can be as small as 1 percent of a CPU.

Do it just as you proposed, your command in the command field, and the rest in the parameter field. Compile your sequence, then review the generated code on the job control tab of the job properties dialog.

Do it just as you proposed, your command in the command field, and the rest in the parameter field. Compile your sequence, then review the generated code on the job control tab of the job properties dialog.

I had a similar problem on version 8 on Windows. My problem was corrected by modifying the LIB and INCLUDE environment varaibles to point to Microsoft Platform SDK. I got no useful information from the logs when I tried to run parallel jobs. It was only by reviewing the installation instructions tha...

You could store values like this in a parameter table, the use my Jobs and routines to integrate a parameter table into a sequence tool. This will allow you to save the date at the end of a successful run, and retrieve it at the beginning of the next run. You will find this and other tools on the Da...

In DataStage Designer, select Tools, then Options. Choose "Default Trigger Colors", then make your trigger colors unique.

You may see on the canvas that your sequence has triggers that do not represent the control flow you are trying to implement.

You could try building your parameter string in a user variable activity stage in your job sequence, then pas that string to your job in the job activity stage.

Ram, My List all files and tables used by jobs in a dsx file recognizes the files and tables in ALL DataStage Server stages, as well as in their user defined SQL. The lastest versions of my tool also recognize parallel sequential, fileset, dataset, lookup fileset, dynamic relational, and oracle stag...

After job 1, use a nested condition activity, calling my Routine called in a sequence to return the row count on a link . It returns the number of rows that traveled the link. Now, add two triggers to the nested condition activity, one trigger for the return value <=0 that would connect to you notif...

In some of the generated code of a job sequence, I have noticed different defaults for some job activity stages. My guess has been that these values are somehow based on the limits set the last time I ran the job. If you can figure this out, then you may have a way to trick the code generator into d...

I, too, am not sure exactly what your requirement is, but my Jobs and routines to integrate a parameter table into a sequence tool provides one method of writing and reading values associated with a run. I typically track the start date of a job, so I know when the last run was initiated. This value...

My tool, List all files and tables used by jobs in a dsx file will provide you with information you can use for impact analysis.

You will find it, and other tools, on the DataStage Tools page of www.anotheritco.com .

I would love to have an active stage that is similar to a hashed file stage with one input and one output link. This stage would not land data on disk, but would allow the incoming row to be normalized on the fly. This would be more flexible than a pivot stage, because one incoming row could generat...

Try my List all files and tables used by jobs and routines in a dsx file. You will find it on the DataStage Tools page of www.anotheritco.com . It understands all server passive stages, and has limited understanding of the following parallel stages: SequentialFile, FileSet, DataSet, LookupFileSet, s...