Hi All,
On my DataStage Server there are various Projects handled by different users. From Last One week Suddenly the execution time taken by DataStage jobs in my project has increased and the throughput has reduced from 400 rows/sec to 30 rows/sec.
I want to check how much is the load on the DataStage Server? I dont have the admin login. Please let me know the ways/commands from which we can check the load on the server. Also what might be the other possible reasons for this slow down?
Thanks in Advance.
DataStage Server Slow Down
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Without a baseline set of measures from the "good times" it's not going to be a lot of help. Your system administrator will be able to brief you on the various tools and techniques; you might like to review the man pages for the following commands:
- top
iostat
vmstat
netstat
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.
Projects don't use memory, jobs do. I would use one user id per project and then measure system memory by userid at runtime to determine what you are looking for.
<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:
There are four major resources: CPU, memory, disk throughput and network throughput. Bottlenecks may also occur in database servers due, among other reasons, to locks. Do not concentrate solely on memory. A system that is CPU-bound may also be memory-bound, but you would not detect the latter until you clear the CPU bottleneck, because it is masking the memory bottleneck.
Seek help from someone nearby who is trained in monitoring operating system performance.
Seek help from someone nearby who is trained in monitoring operating system performance.
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.