WHen I run the Datastage jobs, they are either hanging or aborting.
When I look into the monitor of the jobs which are running for a long time, I see that the time count increasing, but the num rows is still the same. Can I know how to trouble shoot this issue.
Datastage Job Hangs
Moderators: chulett, rschirm, roy
There isn't enough information to make any sort of an analysis; it is like asking a technician at the auto shop to "sometimes my car won't start and sometimes it stalls in traffic. What is wrong?".
Replace your database output stages with peek stages to see if the hangs are caused by writes.
Replace your database output stages with peek stages to see if the hangs are caused by writes.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Oops, I was thinking in terms of PX jobs, there are no peek stages in Server. Just make a copy of your job, replace the database writes with sequential file stages pointing to "/dev/null" and see if you still get a hang.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When the jobs abort, reset them in Director and look in the log for any entry "from previous run" which may contain diagnostic information. Are there any other warning messages in the job logs for these jobs?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.