Job is getting Hanged

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
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Job is getting Hanged

Post by dashpriya »

Hi All,

Actullay I am fetching data from table XYZ and updating the same table XYZ after some transformation. Hence Job is getting Hanged.
please help me.

The solution can be create one more job but we can't.
Now this stage it is very hectic to create new job.

Thanks in Adavance.
arun_kumar
Participant
Posts: 58
Joined: Thu Feb 15, 2007 3:42 pm

Job is getting Hanged

Post by arun_kumar »

Hi,

Which stage your using which database your working for, please give the complete description.then it will be helpful.
Arunkumar..
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Don't ever say "can't". What if the ONLY solution requires you to have two jobs?

Think about what is happening. You are establishing a cursor to select rows from the table, and attempting to perform updates against a table with an open cursor. Will any other tool allow you to do this? Why do you expect DataStage to be able to?

You could replace your single job with a single server job that has an intermediate passive stage, to force a process boundary, but in a parallel job you are causing a self-lock which will hang your job every time.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

which database stages you are using? draw your job stages here
Post Reply