DSXchange

When you imported the table definition from DB2 into DataStage, you got a list of the column names. These are the column names (and data types, etc) that you MUST use in the job design that loads the DB2 table. These and only these. You get away with it in a Sequential File because text files don't ...

The clients will run on any 32-bit Windows environment. Windows 98 is not recommended, however. And Windows 95 definitely not, mainly due to its age (and therefore the age of some of the supporting DLLs). For example, one of my clients is successfully running DataStage 7.1 (both client and server) f...

Every connected DataStage process is allocated a shared memory segment, called the "printer shared memory segment" because the largest structure in it contains preset values for up to sixteen output channels. In UniVerse these are primarily used for printing. These segments may be seen with the comm...

The first idea is that you can't do it in the same job, because a running job can not change the values of its own parameters. Therefore, no matter what method you choose, you're going to need a two phase process, probably controlled by a job sequence. Therefore, however you determine the file name ...

It's not really an issue. All it means is that, in the newer versions, you will get a warning message generated by the Routine compiler if you assign a value to any variable whose name has been used as the name of an input argument, to warn you (implicitly) that DataStage uses pass-by-reference. The...

With fixed-width format the column widths must be correctly specified. During import of thesequential file's "table definition" you enter the widths manually, as a comma-delimited list. Since this is a manual process there is scope for error. The column widths in the file are stored as the Display W...

Welcome aboard! :D You can download CompileAll from the sister site to DSXChange. Once you upgrade to version 7, this functionality is inside the product, called Multiple Job Compile. If you really want to code it yourself, I'd suggest using server side tracing to trace what a "real" compile does, a...

In Director open Status view (disable showing of Categories if the jobs are in different categories). Use the Filter (Ctrl T) to limit the display to the jobs in which you're interested. There's the report you seek. To get a hard copy, choose Print from the Project menu, and check the "print to file...

Run all jobs from a job sequence. Near the end of the log for the job sequence is an entry "summary of sequence run" which contains what you're after.

These are most usually caused by the server machine running out of resources, for example not being able to start (fork) any more processes. That, in turn, usually suggests that you are asking the hardware to do more than it is capable of doing. Your operating system logs ought to report the failure...

Is that same SHLIB_PATH set up in the dsenv file, which every DataStage process gets its environment variable settings? Also check the permissions on the library infmxcli.sl itself (you need at least read and execute permission). If it's neither of those things, then you will need to use the test ut...

(1) Yes. (2) Yes, typically by using a constraint expression in a Transformer stage's output link (for example @INROWNUM <= #RowLimit#). (3) Yes, typically by using a job parameter to specify the starting row number. You must design the counting process into your job design. Again use a constraint (...

Use the "in list" loop rather than the counted loop. The current index value is available to a downstream Job Activity, so you can make the file name a job parameter in the job invoked by it. I was assuming an invariant comma-delimited list of file names when I made the initial suggestion; would hav...

This really belongs on the parallel forum. The message is clear; it's alerting you to the fact that, because of choices you made (that is, to use three players), some players will be handling a greater workload than others. To get an even workload from eight nodes, specify a whole divisor of 8 (for ...

My parallel jobs are failing in one project and the same are succeeding in the other.

What's different between these two projects?

"Nothing" is not the correct answer.