Search found 51 matches
- Fri Oct 30, 2009 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Doubt regarding Aggregator
- Replies: 11
- Views: 6137
The instructions worked just fine for me but then I'm on 7.5.2. Did you highlight the Column for Calculation then scroll the Available Properties to Add over to the right? ... Yes I did..all I could see are many options but not Preserve Type. The availabe properties are: Corrected Sum of Squares Ou...
- Fri Oct 30, 2009 1:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Doubt regarding Aggregator
- Replies: 11
- Views: 6137
please explain me in detail where actually in aggregator stage do we have the option Stage --> properties --> Agrregations ---> aggregation type calculation --> click on column for calculation --> see in available properties to add . I am working on 7.5.1 OS: Unix, but i do not see this option in A...
- Fri Oct 30, 2009 1:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Doubt regarding Aggregator
- Replies: 11
- Views: 6137
please explain me in detail where actually in aggregator stage do we have the option Stage --> properties --> Agrregations ---> aggregation type calculation --> click on column for calculation --> see in available properties to add . I am working on 7.5.1 OS: Unix, but i do not see this option in A...
- Thu Oct 29, 2009 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator stage Inconsistent output
- Replies: 10
- Views: 4108
- Thu Oct 29, 2009 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator stage Inconsistent output
- Replies: 10
- Views: 4108
The answers to the other questions are important as well. Also, how are you detecting that the output is different? Are there just 2 output rows and values are different? If so, what is the output col ... I have given all the required information for the questions... if i run for the first time i a...
- Wed Oct 28, 2009 10:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator stage Inconsistent output
- Replies: 10
- Views: 4108
(a) the names of your grouping columns - Amount Type (b) the names of your hash key columns - Amount Type (c) the names of your sort key columns - Amount Type (d) the Aggregator operation method (hash or sort) - Sort ... And Amount Type has only 2 values in my data sample. The data is static, I am r...
- Wed Oct 28, 2009 4:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator stage Inconsistent output
- Replies: 10
- Views: 4108
Aggregator stage Inconsistent output
Hi, The requirement is to aggregate the Amount column based on Amount Type. I am dealing with the data of around 45 million and currently it has only 2 amount types. I am getting different results each time i run the job. I used to Sort method with a preceding Sort stage and Sort on Amount type with...
- Tue Sep 15, 2009 10:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unrecognized Argument
- Replies: 3
- Views: 2304
- Tue Sep 15, 2009 10:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unrecognized Argument
- Replies: 3
- Views: 2304
Unrecognized Argument
Hi All, we have moved our jobs to production and to our surprise the first job in the flow abended with the following error: Unrecognized Argument: & in all the DB2 Enterprise stages from where we are reading the UDB tables. we did not face this issue in dev.all the jobs ran smoothly. any help o...
- Thu Mar 12, 2009 6:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Socket Operation on a Non-socket
- Replies: 6
- Views: 12990
Re: Socket Operation on a Non-socket
today when i tried to run the same job...voila it ran......but my happiness was short lived as another job failed with same set of errors
still not able to figure out, what exactly the problem is
still not able to figure out, what exactly the problem is
- Wed Mar 11, 2009 11:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Socket Operation on a Non-socket
- Replies: 6
- Views: 12990
And followed up with an extremely slow response... don't really have an answer, is the issue happening on the read or the write? You have to be proud of yourself though, you've achieved the impossible Impossible code statement reached I did the Impossible...but even DS did..till yesterday this job ...
- Wed Mar 11, 2009 7:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Socket Operation on a Non-socket
- Replies: 6
- Views: 12990
Thanks Kryton for the quick reply!! Would imply the server rejected your connection... What is the extra information within: main_program: Unexpected exit status 1 (...) main_program: Unexpected exit status 1 (...) it is actually the same error msg repeated thrice. Would imply the server rejected yo...
- Wed Mar 11, 2009 6:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Socket Operation on a Non-socket
- Replies: 6
- Views: 12990
Socket Operation on a Non-socket
Hi all, a job which used to run normally before is abending now with , following error messages main_program: Unexpected exit status 1 (...) 5615 FATAL Wed Mar 11 18:59:10 2009 FUNL_Combine,3: Failure during execution of operator logic. 5618 FATAL Wed Mar 11 18:59:10 2009 FUNL_Combine,3: Fatal Error...
- Wed Jul 16, 2008 8:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Look Up failure
- Replies: 8
- Views: 4944
I do not have any column with same name from both the ref link and the primary link...peddidsx wrote:This might with the columns with the same name in both master link and reference link which are not used as a key.Try by removing un-used column with the same name in the reference link.Hope this should work
- Wed Jul 16, 2008 7:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Look Up failure
- Replies: 8
- Views: 4944