Search found 42189 matches

by chulett
Sun Jun 24, 2012 7:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File created in server, needs to be read in parallel job
Replies: 3
Views: 2380

The short answer is the same regardless of the source: make the Parallel format specification match the actual file. The fact that it was created by a Server job shouldn't really matter. First question would be about this: delimiter = tab(the actual delimeter is comma) Why not use the "actual d...
by chulett
Sat Jun 23, 2012 2:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key not generated sequentially
Replies: 7
Views: 4238

Well, that's an "if" bridge you can cross when you get there. Do some benchmarks of the single node speed and see if the performance is anything to worry about. Since you are just basically dumping a database to disk, it may not be an issue. If you need to, up the number of nodes and live ...
by chulett
Sat Jun 23, 2012 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key not generated sequentially
Replies: 7
Views: 4238

There's no "priviledge" required to run on any number of nodes, including a single one, you just need the appropriate $APT_CONFIG_FILE file. And you should have several flavors on hand to work with. So, what's stopping you from taking that solution path?
by chulett
Sat Jun 23, 2012 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: stringtoTimestamp
Replies: 2
Views: 1705

Show us your syntax.
by chulett
Sat Jun 23, 2012 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key not generated sequentially
Replies: 7
Views: 4238

I would assume because of the two nodes and yes I know you've said you're running the transformer sequentially. What happens when you run it on a single node?
by chulett
Fri Jun 22, 2012 5:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IPC timeout issue
Replies: 5
Views: 2452

Just really asking for the link. :wink:

Thanks.
by chulett
Fri Jun 22, 2012 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IPC timeout issue
Replies: 5
Views: 2452

Interesting... no other post out here (and there are quite a few) mentions "OLD TIMEOUT BEHAVIOR". Where did you find this, can you post a link?
by chulett
Fri Jun 22, 2012 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C++ compiler problem
Replies: 11
Views: 7493

disable operator combination for the transformer stage and recompile and post the result Just as an FYI, this only needs to be suggested when the error is from the "combined operator" and it is unclear what stage is actually generating the error. We know who the culprit is here. :wink: Ou...
by chulett
Fri Jun 22, 2012 10:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: could not map table file, cannot allocate memory
Replies: 2
Views: 1875

Start by doing an exact search here for "could not map table file", it has been discussed a number of times.
by chulett
Fri Jun 22, 2012 9:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of reference links limit
Replies: 15
Views: 8182

There's no difference between doing X lookups in 1 stage versus doing 1 lookup in X stages, other than the 'clutter' on the canvas. If you didn't get the 'desired result' all clumped into one, I doubt anything will change if you separate them out. If you are looking for help with getting your desire...
by chulett
Fri Jun 22, 2012 8:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML output for combination of keys
Replies: 3
Views: 1986

Since there's (apparently) no "RTI" component to your Server job, moved your post from that forum to here.
by chulett
Fri Jun 22, 2012 7:24 am
Forum: General
Topic: How to read .spps data using Datastage?
Replies: 2
Views: 1236

Oddly enough, SPSS is an IBM preditive analytics product. I would imagine your official support provider would be able to help you with that.
by chulett
Fri Jun 22, 2012 7:18 am
Forum: General
Topic: JobControl (fatal error from @Coordinator)
Replies: 6
Views: 4462

03:29:34: Exception raised: @jDM0005AllDriverProgram, Error calling DSRunJob(jDM0005AllDriverProgram), code=-99 [General repository interface 'other error'] 03:29:34: Exception raised: @Coordinator, Error calling DSWaitForJob(), code=-99 [General repository interface 'other error'] 03:29:34: Sequen...
by chulett
Thu Jun 21, 2012 8:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage
Replies: 13
Views: 5044

Kryt0n wrote:is a bit like pulling teeth with your nasal hair
That's a new one on me and left quite a picture in my mind. :wink:
by chulett
Thu Jun 21, 2012 6:49 pm
Forum: IBM QualityStage
Topic: QualityStage MNS AddressTypeIndicator values?
Replies: 1
Views: 2230

Done. :wink: