All jobs deleted from the project

reddy · Post by **reddy** » Wed Mar 21, 2007 5:41 pm

Hi,

Good evening.All jobs are deleted suddenly in one of my project but other projects having jobs.Could you please help me on what happened exactly.
Is some one deleted or some datastage issue.
I appreciate your help and time.

Regards
Narasa

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 5:54 pm

You sure the jobs are deleted or they are just not visible in the repository?
Click on new, in the designer and go to the last tab, its called Recent Jobs, I think. You should see your most recently accessed jobs there. Click on any one and hit Open. If the job pops open, that means the jobs are there, its just an index issue.
To solve that, search for RE.INDEX ALL here and follow the steps.

reddy · Post by **reddy** » Wed Mar 21, 2007 6:48 pm

Thanks for quick response.

I followed the following steps but I couldn't recover jobs.

DIVERT.OUT ON &UFD& reindex.log
DS.REINDEX ALL
DIVERT.OUT OFF

Can you please help me on this.

Regards
Narasa

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 8:06 pm

Was everyone signed off when you did REINDEX ALL?
Try creating a job which was already present. If it does'nt allow you to do it that means the jobs are there. You need to run reindex again with everyone signed off from the server. If you are able to create an identical named job, that means your jobs are all gone. Query the DS_AUDIT table to know what happened to these jobs and who deleted them. Search about DS_AUDIT here.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 21, 2007 8:33 pm

Were there any messages in your log indicating that there was a lock held so that BUILD.INDEX could not proceed?

That means that you did not have exclusive access to the project.

Issue the following command and let us know the outcome.

Code: Select all

SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';

This will count the number of job names in the project.

reddy · Post by **reddy** » Thu Mar 22, 2007 9:00 am

Thanks for response.
I have administartive rights but when I used SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%'; it is showing only one count.It supposed to have 500 jobs.
When I ran REINDEX on DS_JOBS it is showing following messages.
* Re-indexing DataStage Repository file: DS_JOBS
File "DS_JOBS" has no indices.

Thanks for help.

Reddy

ray.wurlod · Post by **ray.wurlod** » Thu Mar 22, 2007 6:55 pm

Merde.

Someone has deleted all your jobs.

Do you have a backup or an export?