Datastage Jobs Running Very Slow
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Fri Jul 28, 2006 2:11 pm
Datastage Jobs Running Very Slow
All of sudden all the datajobs in our production environment has started running slow.
We have made no changes to any of the jobs in last 2 months.No virus scan is running on the server.Disks,memory,CPU usage all seems ok to us.
Any idea what could be the reaso behind is highly appreciated.
Cheers
We have made no changes to any of the jobs in last 2 months.No virus scan is running on the server.Disks,memory,CPU usage all seems ok to us.
Any idea what could be the reaso behind is highly appreciated.
Cheers
Database speed? Network load?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 27
- Joined: Fri Jul 28, 2006 2:11 pm
Re: Datastage Jobs Running Very Slow
Database speed is fine,all the tables are analyzed and stats are gathered on weekly basis.Network load is also same as usual.There are no error or log which suggests anything fishy.
The problem is with all the jobs.
The problem is with all the jobs.
Sunshine
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Datastage Jobs Running Very Slow
Sudden ??amitendra_amit wrote:All of sudden all the datajobs in our production environment has started running slow.
-
- Participant
- Posts: 27
- Joined: Fri Jul 28, 2006 2:11 pm
I cleared the &PH& folder and ran some jobs but I dont see any improvement.There is no delay in triggering the jobs from sequencer.Atleast as far as I can see in director.
Yeah it started suddenly couple of days ago, the jobs which were taking 3 mins previously are now taking 15 mins.The problem is not specific to few jobs but to all the jobs .
Yeah it started suddenly couple of days ago, the jobs which were taking 3 mins previously are now taking 15 mins.The problem is not specific to few jobs but to all the jobs .
Sunshine
It is very doubtful that increased job runs across the board are caused by problems internal to DataStage. However, you can stop and re-start the DataStage engine just to be sure.
It could be numerous things including:
1) Contention on the Database / Database Server
2) Network traffic
3) resource constraints on any of the systems (memory / CPU)
If you are on a multi-tier system, first pin it down to a system if you can by pointing to or running jobs from a different system. Once you've got it pinned down to a system then it is just old fashioned admin / dba detective work.
It could be numerous things including:
1) Contention on the Database / Database Server
2) Network traffic
3) resource constraints on any of the systems (memory / CPU)
If you are on a multi-tier system, first pin it down to a system if you can by pointing to or running jobs from a different system. Once you've got it pinned down to a system then it is just old fashioned admin / dba detective work.
Have you got this issue resolved .If so what did you do .I am seeing same issue in my environmentamitendra_amit wrote:I cleared the &PH& folder and ran some jobs but I dont see any improvement.There is no delay in triggering the jobs from sequencer.Atleast as far as I can see in director.
Yeah it started suddenly couple of days ago, the jobs which were taking 3 mins previously are now taking 15 mins.The problem is not specific to few jobs but to all the jobs .
deepthi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We are having Universe database .This is a Windows server .I am checking with Intel to see if they have applied any windows patches but as far as datstage no deploymnets or no change to any jobs .
After setting up the environment variables sequencer is taking 20 minutes to start the job .Once the job starts it finishes in seconds .It is just hangs at that specific point 20 minutes for every job . I have to try clearing the &PH& file .
After setting up the environment variables sequencer is taking 20 minutes to start the job .Once the job starts it finishes in seconds .It is just hangs at that specific point 20 minutes for every job . I have to try clearing the &PH& file .
deepthi