Hi all,
I am running a job which extratcs data from one Oracle database passes trough a transform and loads into another oracle DB. Last week it ran at 100 rows/sec now its running at lessthan 1 row/sec.
We tested the sql code on oracle DB its running fine. It seems their is some problem with datastage server.
Any tips of how to find the problem?
thanks,
performance issue
Moderators: chulett, rschirm, roy
Write your data to a sequential file and read it from that file. That will give you the effective speed of all stages leading to the file stage and also the effective speed of all stages after the file stage. This will help you narrow down the cause of the speed slowdown. You can continue doing this by moving the sequential write/read stage to different parts of your job.
Also, does your transform stage have a high %CPU (in that case you are bound by processing capability). Chances are very high that Oracle is the culprit, so monitoring that will give you the best results.
Also, does your transform stage have a high %CPU (in that case you are bound by processing capability). Chances are very high that Oracle is the culprit, so monitoring that will give you the best results.
<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:
Re: performance issue
What has changed in the meantime? If the DataStage job has not been changed clearly it can not be the culprit.pkomalla wrote:We tested the sql code on oracle DB its running fine. It seems their is some problem with datastage server.
Any tips of how to find the problem?
What is the total other load on the machine? For example, are you running lots of other work - DataStage or otherwise - that you weren't running when performance (whatever that means) was acceptable?
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.
Re: performance issue
pkomalla wrote:Hi all,
I am running a job which extratcs data from one Oracle database passes trough a transform and loads into another oracle DB. Last week it ran at 100 rows/sec now its running at lessthan 1 row/sec.
We tested the sql code on oracle DB its running fine. It seems their is some problem with datastage server.
Any tips of how to find the problem?
thanks,
I'd suggest running an ANALYZE in your Oracle DB to regenerate the stats for the optimizer.
Try running your SQL within the database and check the performance. I doubt it's a DataStage issue.