Hi
Since we migrate to the 7.1r2 from the 7.1r1 we have some issues.
We have job that run forerever.
We have job that last 2:44 minutes r1 and now last 47:28 minutes.
Did someone encounter the sames troubles ?
Thanks for Helping
Performance with 7.1r2
Moderators: chulett, rschirm, roy
No, I haven't seen anything like that. What does your job do? Did you change anything else at the same time (OS or patch level, DB version, etc.)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If you write to a sequential file instead of DB2 does it speed up greatly? (it should, if not you do have some issue). Do other jobs that write to DB2 also show a slowdown?
<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:
Hi,
I'm sorry for the delay.
I changed my job by deleting the link collector and using a pivot stage.
The job runs with the time it had in the previous version.
I'm just worried about the behavior of Datastage. A minor change shoudn't have a huge impact.
I have to change a lot of jobs , because they hang in r2 plus the solution that the support gave me works in dev but not in production.
Thanks for helping.
I'm sorry for the delay.
I changed my job by deleting the link collector and using a pivot stage.
The job runs with the time it had in the previous version.
I'm just worried about the behavior of Datastage. A minor change shoudn't have a huge impact.
I have to change a lot of jobs , because they hang in r2 plus the solution that the support gave me works in dev but not in production.
Thanks for helping.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Any version number containing "r" is a "rapid repair fix" and has not been through full Quality Assurance testing. You should contact your support provider for a version that has been through full QA testing.
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.
Hi,
I've the same problem toda...
viewtopic.php?t=106909
"job running but no log, no PID, too long, CPU Pb ?"
Big coincidence !
I've the same problem toda...
viewtopic.php?t=106909
"job running but no log, no PID, too long, CPU Pb ?"
Big coincidence !
shrek7577 - it doesn't look like quite the same problem to me, this is a n extreme slowdown type of issue while what you described was quite the opposite, where the job doesn't terminate correctly.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>