DSXchange

I've done this in that past, and didn't run into the issues that you're having. But it sounds like the NZ connector is throwing warnings on column and column type mismatches between your select statement and the output columns that you have defined. How are you selectingdata from your Netezza connec...

If it runs on four nodes, I bet it'll quadruple the data.

I'm guessing that your modulo and your partitioning in DB2 aren't the same. So, effectively, your SQL statement, that runs on each partition, is not constraining its results to the records that are on that partition.

Can you write an SQL statement that selects the system tables, and returns the column names of the table in question?

Or... a substring of the column names in question?

If you absolutely must have sequential numbers (and it doesn't sound like you do), then you should probably tie it to something inside the target database itself (e.g. built-in key generator? rowid?), or grabbing the max(key_field) from the table in question, and using that as a feed to increment it...

In production only one instance of the job would ever run, which is why we have not made it a multiple instance job. This is a requirement to support multiple test streams. Therefore, is the consensus of opinion that multiple instances of a job cannot be run on one data stage engine, without making...

We use a JDBC connector because the DB2 connector was losing rows and IBM couldn't identify why. ... <snip> ... I'm am willing to entertain any suggestions you have. We use 11.5 on a linux machine. Honestly, I'd circle back to figuring out the DB2 connector. Like others have pointed out, figuring o...

Yes, my main sequence also runs multiple times. My job runs for few minutes so I am not sure if adding few seconds sleep would help. Also, if I do that how I am going to achieve parallelism? Your thoughts please. However, I am going to try on your suggestion and will let you know the outcome. Thank...

While monitoring a running job from designer, performace statistics for containers are not shown. After all those years, it would be beneficial to see the statistics in the local containers... I know that this is an old thread, but this was one of my annoyances as well. DS 11.5 (and maybe 11.3) has...