error writing from ds to look file set

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
deeps
Participant
Posts: 6
Joined: Tue May 02, 2006 9:38 am
Location: india

error writing from ds to look file set

Post by deeps »

Hi,
Facing some strange problem when reading from a single dataset and writing to multiple lookup sets. The job fails with error message:

dspipe_wait(27990): Writer timed out waiting for Reader to connect.

Whats peculiar is the problem does not occur when we run the job individually. It occurs only when we try running it through sequence control.
Any clues what could be the problem?

TIA
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You need to delete your partial post on this same subject before someone replies to it. Once there is a reply, you can't.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

It shows your server is getting loaded heavily.
What is the load at the time when it is called using sequencer.
What is the volume of the data that getting written in to Lookup file set?
Is your IO occuring at different locations?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
deeps
Participant
Posts: 6
Joined: Tue May 02, 2006 9:38 am
Location: india

Post by deeps »

kumar_s wrote:It shows your server is getting loaded heavily.
What is the load at the time when it is called using sequencer.
What is the volume of the data that getting written in to Lookup file set?
Is your IO occuring at different locations?


thanks ..... tried reducing the load on a single job .... it worked :-)
Post Reply