Page 1 of 1
All the jobs missing from the project
Posted: Mon Mar 28, 2005 12:00 pm
by sumitgulati
We have a Project which was working fine until Thursday. On Friday whichever jobs we triggered showed RUNNING in director but they were actually not running when checked in the UNIX box. Even if they were running, they were in idle state. Jobs are in idle state since friday.
Today(Monday) when we logged in we found no jobs showing up in the director (OR any client application). The jobs are present in the repository, like when we check RT_**** file they are all present in the DS host machine. We also checked DS_JOBS and we have the jobs present in there too.
Does anyone have any clue how can we get the jobs show up in the Director. We Recreated the Indexes but it did not help. Currently trying the integrity option.
Posted: Mon Mar 28, 2005 12:13 pm
by ketfos
Hi,
Can you see the jobs in Designer?
Ketfos
Posted: Mon Mar 28, 2005 12:20 pm
by sumitgulati
No, The jobs are not visible in any of client applications - Directory, Designer OR Manager.
Regards,
-Sumit
Posted: Mon Mar 28, 2005 12:28 pm
by ketfos
Hi,
Are you able to view the routines/functions in the Project in question?
Are you able to create new jobs in the Project in question?
Did you try to bring the server down and up?
Ketfos
Posted: Mon Mar 28, 2005 12:40 pm
by sumitgulati
Routines are visible in Manager.
I can create a new job but that job also does not show up in any of the clients.
No, we did not bring the server down. This is something not controlled by and and will be done by the administrator at the end of the day.
Regards,
-Sumit
ketfos wrote:Hi,
Are you able to view the routines/functions in the Project in question?
Are you able to create new jobs in the Project in question?
Did you try to bring the server down and up?
Ketfos
Posted: Mon Mar 28, 2005 1:07 pm
by ketfos
Hi,
Did you check in the Designer under Tools ---> Options --->Appeareance--->Repository Tree--->Category Customization ....
Is Show Jobs Selected under Category Customization ?
Ketfos
Posted: Mon Mar 28, 2005 1:15 pm
by sumitgulati
Yaa Ketfos, This is checked.
We also just tried bouncing the server. The jobs still don't showup.
Regards
-Sumit
ketfos wrote:Hi,
Did you check in the Designer under Tools ---> Options --->Appeareance--->Repository Tree--->Category Customization ....
Is Show Jobs Selected under Category Customization ?
Ketfos
Posted: Mon Mar 28, 2005 1:28 pm
by ray.wurlod
It's almost certainly indexing in the Repository.
Find a time when there are no developers connected and no jobs running and, logged in as DataStage administrator, execute the command
(from the Administrator client Command window or from a telnet session running
dssh in the project directory).
Posted: Mon Mar 28, 2005 1:47 pm
by sumitgulati
We found the issue. Actually we did not notice that when we were recreating the indexes it was not doing it on DS_JOBS because DS_JOBS was locked by another process. We bounced our server and ran REINDEX on DS_JOBS. All our jobs are now visible in Director.
Thanks for all the suggestions,
-Sumit
Posted: Mon Mar 28, 2005 2:34 pm
by kollurianu
what does datatstage bouncing means?
Any help appreciated,
Thank you
Posted: Mon Mar 28, 2005 2:37 pm
by chulett
Stopping and restarting. Going down and back up like a rubber ball, hence the term "bouncing".
Posted: Mon Mar 28, 2005 2:54 pm
by kollurianu
Thank you Chulett.