Search found 46 matches

by vikibemech
Fri Oct 16, 2009 7:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage logs
Replies: 6
Views: 2671

Andrw,

I am not able to see you full comments since I am not a premium member of this forum.
by vikibemech
Fri Oct 16, 2009 6:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage logs
Replies: 6
Views: 2671

Datastage logs

Hi,

I am able to see logs only for last 10 runs in DS Director. If I want to see the logs for previous day (last before 10 days), please advice the steps to follow.
by vikibemech
Thu Oct 15, 2009 5:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage Jobname.transfermerstahename d
Replies: 8
Views: 3503

Abnormal termination.

yes chulet, You are right. We are not ableto rest the job. When we are trying to do so, job is runnign and getting abort. Even I am facing this issue from yesterday. Please advice.
by vikibemech
Sun Aug 30, 2009 11:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Identified the policy no which is creatign the issue. Filter the policy in transformer stage by a constraint. Job completed succesfully.
by vikibemech
Fri Aug 28, 2009 2:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Divident by zero

Thanks for the info provided till now. Issue has been resolved now.
by vikibemech
Thu Aug 27, 2009 6:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Dividend by zero

DataStage Job 1130 Phantom 10132 Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned. Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division by zero, zero returned. Program "JOB.867233938.DT.1505838351.TRANS4": Line 111, Div...
by vikibemech
Thu Aug 27, 2009 5:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Dividend by zero

By seeing the log in Director, I have taken the transformer count (4th trans in log). Error msg i have mentioned above. 5 columns coming as input to transformer (as mentioned above). let me know if you have any questions.
by vikibemech
Thu Aug 27, 2009 5:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Dividend by zero

Policy no, Value 1, Value 2, Vlaue 3, Value 4
12345, 1, 0, 0, 0
23456, 0, 1, 0, 0
34567, 0,0, 0, 1
53265, 0, 0, 1, 0
by vikibemech
Thu Aug 27, 2009 5:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Dividend by zero

I have zero's in this row like other rows. But the issue is only with these rows.
by vikibemech
Thu Aug 27, 2009 5:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

I have Stage Vaiable with If else if conditions. No arithmatic calculation found. In stage Vaiable, operator used is <>. nothing else.
by vikibemech
Thu Aug 27, 2009 5:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Dividend by zero

thanks for the info. I walked through the trans4 stage and there is no arithmatic division in any of the column. My design is like this Seq file-> Agg -> Hash file ->transformer. Hash file input is 10K records but output is only 33 records(which is the input for Transformer). I am not clear where th...
by vikibemech
Tue Aug 11, 2009 2:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Re:Divident by zero

In the job I have many transformers. I am not clear what Trans4 mean? Coudl you please explain briefy.
by vikibemech
Thu Aug 06, 2009 1:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Divident by zero
Replies: 27
Views: 7482

Divident by zero

I am getting an error as below and not able to move forward to resolve. Please advice if any. DataStage Job 1130 Phantom 10132 Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned. Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division...
by vikibemech
Wed Apr 22, 2009 12:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom / timeout waiting for mutex error
Replies: 7
Views: 5001

Phantom / timeout waiting for mutex error

Hi,

I am working in Maintainance & support project. DS jobs are getting failed often because of Phantom error & mutex error. Few jobs are not able to start running in seq level and not showing any error messages in logs but the seq will be aborted. Please advice
by vikibemech
Tue Feb 03, 2009 11:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What should be in Job documentation?
Replies: 2
Views: 777

Job Documentation

I am very much aware of the option. Is it possible to directly generate report to word document. I am trying to pull the report in word but not able to to. Throwing an error: "An invalid character fount in text content". Advice