DSXchange

I have a *.txt comma delimited file on the server. If I use the Server version of DS, I can view the data and process it. When I use the Parallel version, the view option abort and cannot process the file. I changed some defaults to DOS format and still not viewing the data. Could someone please exp...

It was the load balancing the staggers the numbers. I have 4 node processing 111 records, Partition 0,1,2,3. Part 0 contained 1-27, Part 1 contained 1-26, part 2 contained 1-26 and part 3 contained 1-32. Using the formula to assign keys staggers the counts by 4. So the last partition 3 contained num...

When I generate a unique partitioned key using @PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 + MAXEVNTID Where MAXEVNTID = max value from the last job execution, The DB2 table sequentially increment the key by 1 on different partitions. So far so good. When the key sequence number hit 100, ...

Thank you very much...I can't tell you how much this has frustrated me. Thank god for this forum..

I am trying to understand the partitioning mechanism with DS and cannot seem to get it working properly. In the Transformer stage I created a Stage Variable containing the init. value as @PARTITIONNUM - @NUMPARTITIONS + 1 =====> Stored in svCounter In my stage derivation I put MAXEVNTID + svCounter ...

Could someone please tell me what version it says under the help "About DataStage Designer" panel on the EE platform. We installed the server version as well and now it refers to the server version. Is it always been that way. Also, after the install, the designer pallette is screwed up an...

Well I thought it was going to be simple. I coded the following line in the Transformer Stage variable and it didn't like it. Derivation Stage Variable StageName.$UserStatus + @NUMPARTITIONS >>>>> svCounter It can find StageName.$UserStatus STageName = Transformer_200 I wish the manual had more exam...

Hopefully my last question for this topic. I created a server job that reads from DB2 into a transformer stage variable. The value is stored in the userstatus through a routine. Because I don't have an output area defined, I receive errors. How can I get around this without writing to output. Is the...

You're right, we installed the wrong version. Thanks for all your help

We had the parallel engine installed. I have been inquiring about SetUserStatus function that works only in Server version. We installed the server version and now the parallel jobs tell me that they don't run on this version. I recompiled the jobs and still got the same error.

Can we install the Server and Parallel engine on the same box. If so,is there a sequence to install both. We just install the server and now all parallel job won't run.

Thanks

I checked our license structure and we do have the server version. If I install the server version, will it be a separate program icon or will it appear when I open up the NEW dialog box.

Is there a way to setup a server job with the PX version. We never had the server version. I checked the NEW program function and it only has the parallel job creation option.

What are my options if this is not possible. I thought I could use the SetUserStatus to store my variable to be used later in the Job Sequence Stream. I guess I am back to storing the values in a sequential file.

I created a routine and tried to call it in the derivation of the stage variable, I kepp getting told that my routine doesn't exist. Is there an environment variable that needs to be turned on