All the jobs missing from the project

sumitgulati · Post by **sumitgulati** » Mon Mar 28, 2005 12:00 pm

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.

ketfos · Post by **ketfos** » Mon Mar 28, 2005 12:13 pm

Hi,
Can you see the jobs in Designer?

Ketfos

sumitgulati · Post by **sumitgulati** » Mon Mar 28, 2005 12:20 pm

No, The jobs are not visible in any of client applications - Directory, Designer OR Manager.

Regards,
-Sumit

ketfos · Post by **ketfos** » Mon Mar 28, 2005 12:28 pm

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

sumitgulati · Post by **sumitgulati** » Mon Mar 28, 2005 12:40 pm

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

ketfos · Post by **ketfos** » Mon Mar 28, 2005 1:07 pm

Hi,
Did you check in the Designer under Tools ---> Options --->Appeareance--->Repository Tree--->Category Customization ....

Is Show Jobs Selected under Category Customization ?

Ketfos

sumitgulati · Post by **sumitgulati** » Mon Mar 28, 2005 1:15 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Mar 28, 2005 1:28 pm

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

Code: Select all

DS.REINDEX ALL

(from the Administrator client Command window or from a telnet session running dssh in the project directory).

sumitgulati · Post by **sumitgulati** » Mon Mar 28, 2005 1:47 pm

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

kollurianu · Post by **kollurianu** » Mon Mar 28, 2005 2:34 pm

what does datatstage bouncing means?
Any help appreciated,

Thank you

chulett · Post by **chulett** » Mon Mar 28, 2005 2:37 pm

Stopping and restarting. Going down and back up like a rubber ball, hence the term "bouncing".

kollurianu · Post by **kollurianu** » Mon Mar 28, 2005 2:54 pm

Thank you Chulett.