I am running a job sequence containing 7 parallel jobs. All the 7 jobs are running in parallel. Each job has below design.
Sequence File ---> Transformer ---> DB2 Table(DB2 EE Stage, Load and truncate method)
Sometimes all the individual jobs are in hanged state. The datastage director shows all the jobs in running state but no data is actually getting inserted into underlying table. Then I use to stop all 7 parallel jobs and clear the underlying table from load pending state and re-start the main job sequence.
After doing this, the job sequence runs fine. Need to know why the jobs are getting hanged.
I checked the network traffic, Memory, CPU Utilization, table space etc...Everything is fine.
Don't know why this thing is happening. These jobs are in production and I have executed them more than 100 times so far without any trouble.
Any idea.?
Parallel Jobs hanging in DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Try identifying one process and doing a "truss" on it to see which (if any) system calls are being generated.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>