Search found 8 matches
- Thu Mar 08, 2018 10:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using Netezza connector as lookup
- Replies: 4
- Views: 3487
Re: Using Netezza connector as lookup
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...
- Thu Aug 31, 2017 1:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 connector - doubling records
- Replies: 3
- Views: 4317
Re: DB2 connector - doubling records
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.
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.
- Thu Aug 31, 2017 1:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting Month Name from Column Name
- Replies: 4
- Views: 4341
- Thu Aug 31, 2017 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence number using Surrogate Key in transformer
- Replies: 6
- Views: 6308
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...
- Thu Aug 31, 2017 9:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job datasets
- Replies: 8
- Views: 7205
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...
- Thu Aug 31, 2017 7:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create SQL statements instead of using database stages
- Replies: 11
- Views: 8580
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...
- Wed Aug 30, 2017 1:46 pm
- Forum: General
- Topic: Calling the same job multiple times in parallel
- Replies: 8
- Views: 5941
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...
- Wed Aug 30, 2017 1:34 pm
- Forum: Enhancement Wish List
- Topic: Make 'Show performance statistics' work for local containers
- Replies: 2
- Views: 19270
Re: Make 'Show performance statistics' work for local contai
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...