DSXchange

Hi, This is my first test of a trivial parallel DB2/UDB Enterprise stage job. Just to check the new (and first) DSEE setup. Can anyone tell me what i'm doing wrong. The DSEE server is the same one as the DB2EEE server. I gave the following config file: { node "node1" { fastname "englf...

Does anyone know wether the GNU gcc compiler will be supported on the future version (Hawk) of Datastage Enterprise Edition on UNIX (Solaris in my case)?

Thanks in advance,
Wim

Ray,

indeed. I like it that DataStage is integrated as much as possible. But it doesn't have a scheduler/monitor that answers to some requirements, as the one that was discussed higher in this topic. Would it be a priority for Ascential to ad more functionality (like this one) into the scheduler?

How can I verify the success or failure of a UDBLoad Stage? After the UDBStage is finished, I would like to perform a check that the load has performed it's task successfully, completely. One of the ways in which I tried to achieve this, was to look ate the DB2 load generated message file. But no lu...

In the latest posts, the question is raised on what is or should be the relation between DataStage and an external scheduler. From my exerience in ETL it is a BIG plus if a ETL tool has its own sheduler. Because it are the same people who do the set up of the system, who receive functional AND opera...

Thanks everybody,

I understand now. I'll control the 'N'-parallelism explicitely, without complex logic and without sleeps.

I wrote a Sequence Job, in which many Server Jobs run in parallel. This design corresponds to the functional requirements of the project but when all there server jobs start simultaneously, the accessed database is overloaded. I would like to keep the parallel design in the Server Job, but then I'd ...

Well well well, I just experienced the same problem, while persuing exactly the same goal as rdy. In our case the server machine is a Sun, so this is not the pratform where the problem doesn't appear. :evil: The problem is very simple: parameter substitution doesn't happen in the call of a UNIX comm...

Thanks for all the help.
Your answers come faster then I can react to.

It suffied indeed to write the unix filter command 'tail +2' into the filter of the sequential file stage where I read the file.

Thanks,
Wim

Chuck,

I believe your answer is what I need to get the unix command into the pipe as I require.
I will try this out.

Thanks to all,
Wim

I understand your answers, but they require that space is allocated for the intermediate file and that these files be handleded correctly. A Named Pipe would also be a solution for the intermediate file, but this also needs to be set up and managed in a reliable way. That's not always easy to do. Al...

I have a sequential file where the first line is to be ignored. However, it is not a title line, and the number of fields in the first line is smaller then in the following data lines. This last fact makes the use of the use of the Sequential File stage, and the option "First line is column nam...