We have master sequence activities which call another set of sub master sequence activities and these sub master sequence activities call the jobs. The problem that we are facing from thelast 2 months is that the jobs froze (not the same but different places).
Previously we had this probelm once in two weeks but now it has increased to once in a week.
We have two more projects in the same project but they do not have any such probelms. I have tried everything (log puging , not applying MS patches etc.) but nothing seem to work. I am now out of solutions.
ANy help will be appreciated...Do i sound Frustrated??;)
Job Not doing anything.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Symptoms? What were the most recent events logged? Have you got any progress reporting so that you can pinpoint the point of "failure" more accurately? My advice would be to put some in - maybe just before-stage and after-stage subroutines that report "got this far - in stage xyz".
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.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: Job Not doing anything.
whenever you run a job it writes RT_LOG file, it stores warnings, errors .......information, so if you have 1 million record and for every record a warning is created then the size of the RT_LOG is going to increase and it will show memory full and it will not run that job it frozes..........DeepakCorning wrote:We have master sequence activities which call another set of sub master sequence activities and these sub master sequence activities call the jobs. The problem that we are facing from thelast 2 months is that the jobs froze (not the same but different places).
Previously we had this probelm once in two weeks but now it has increased to once in a week.
We have two more projects in the same project but they do not have any such probelms. I have tried everything (log puging , not applying MS patches etc.) but nothing seem to work. I am now out of solutions.
ANy help will be appreciated...Do i sound Frustrated??;)
so check out for the last DSJOB it got stuck and try to rectify that job......play aroung with it
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: Job Not doing anything.
Thats informative.Any idea how much shuld I let the RT_LOGnnn to grow?.
Depending on this I can archive the Logs in a file and purge all of them once in 7 days may be.
Depending on this I can archive the Logs in a file and purge all of them once in 7 days may be.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: