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
All jobs deleted from the project
Moderators: chulett, rschirm, roy
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.This will count the number of job names in the project.
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 '\\%';
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.
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: