link collector error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

link collector error

Post by kollurianu »

Hi All,

I have three output links coming from the three transformers and

iam using link collector to combine these data from above three links

and the output from the link collector is to sequential stage ,

iam getting the following errors when iam running the job ,

NamedAccountNEW..HQ_LkUp.DSLink240: ds_ipcopen() - Error in open(/tmp/dev_proj.NamedAccountNEW..HQ_LkUp-Link_Collector_246.DSLink240) - No such file or directory


NamedAccountNEW..Link_Collector_246: |Error 11 in GCI Link initialisation.|


Attempting to Cleanup after ABORT raised in stage NamedAccountNEW..Link_Collector_246


NamedAccountNEW..opfile.DSLink228: Run stopped after 11969 rows

and the job is Aborted.


And there is red link going from Link Collector to Sequential stage.

Any Ideas,

Thank you ,


















[/code]
manteena
Premium Member
Premium Member
Posts: 38
Joined: Thu Feb 10, 2005 1:43 pm
Location: USA

Temp file error

Post by manteena »

load the each TX output to the seq files and them connect the file outputs to the LC then to the target file.
If u don't want the intermediate files, you can always delete them from after the job subroutine
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

Post by kollurianu »

Hi manteena,

Thank you for ur quick response,

But I donot think that is the issue , i have design having all links from transformer to linkcollector that job works fine,

could some please explain , why am i getting those errors.

Thank you all
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

Post by kollurianu »

Thank you very much Manteena ,

i tried your method , but instead of sequential stage , i used IPC stage ,

that worked.

But i just need a clarification , on using LC , like on how would i know

whether i need to use sequential stage or IPC stage before or after link collector,

any guidance , greatly appreciated.

Thank you all once again.
manteena
Premium Member
Premium Member
Posts: 38
Joined: Thu Feb 10, 2005 1:43 pm
Location: USA

Post by manteena »

kollurianu wrote:Thank you very much Manteena ,

i tried your method , but instead of sequential stage , i used IPC stage ,

that worked.

But i just need a clarification , on using LC , like on how would i know

whether i need to use sequential stage or IPC stage before or after link collector,

any guidance , greatly appreciated.

Thank you all once again.


Great!!! you figured it out.
Looking at your error message "No such file or directory"
I think this file is temp file placed by the DS between two active inks.
By placing IPC DS will not write to the temp files..
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

Post by kollurianu »

Thank you so much Manteena for your answer.

Thank you all
trokosz
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 16, 2004 6:38 pm
Contact:

Post by trokosz »

Link Collector and IPC are totally different in what they accomplish....you can't mix one over the other
aartlett
Charter Member
Charter Member
Posts: 152
Joined: Fri Apr 23, 2004 6:44 pm
Location: Australia

Post by aartlett »

Link collectors from active stages should have IPC turned on in the tunables.

If you have lots of processors on your box, you might even get a performance boost.
Andrew

Think outside the Datastage you work in.

There is no True Way, but there are true ways.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Link collectors from active stages should must have IPCrow buffering turned on in the tunables.

IPC is a stage type, that makes row buffering explicit. However, both the Link Partitioner and Link Collector stages also use the same libraries to refer to the data buffers.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ak77
Charter Member
Charter Member
Posts: 70
Joined: Thu Jun 23, 2005 5:47 pm
Location: Oklahoma

Post by ak77 »

Hi everybody,

I had a similar problem
Is it good to include a sequential stage or IPC stage between transformer and Link Collector? I already had the Inter-Process turned on with default settings
Mine worked with the sequential stage in between but the time taken to run this job was much longer

Then I tried just the partioner in a job and collector in the following job
This seems to be much faster


I dont know if this is the best way but it works

Can somebody give thought to this?

Thanks

Kishan
Post Reply