After Index rebuilding I cant see any job.

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
talk2shaanc
Charter Member
Charter Member
Posts: 199
Joined: Tue Jan 18, 2005 2:50 am
Location: India

After Index rebuilding I cant see any job.

Post by talk2shaanc »

One of our guys tried to rebuild index "DS.REINDEX ALL" Through DS Admin.
Since then, we are unable to see the jobs in that project, on the DS designer pallete or in manager or dir. I am not sure that it happened due to that or some other thing. Few unusual thing.
1. While opening job, if we click on recent jobs we could see jobs as well as open them.
2. If we do batch compilation of job, I can see all the jobs in the wizard.
3. If I create a new job, it gets created but again I cant see that job in any of the DS clients.
4. If i create a job with same name as existing one, it says job already exist.
5. Another user, it seems had one of designer session open. He can see all the jobs, But other users cant.

Can anyone help me on this.
Can
Shantanu Choudhary
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It suggests that the index rebuild was not successful.

Try

Code: Select all

LIST.INDEX DS_JOBS ALL
LIST.INDEX DS_JOBOBJECTS ALL 
to determine whether any of their indices needs to be rebuilt.

Make sure you're logged in with Administrator access, and that no-one else is using the Repository when rebuilding indexes. The following command sequence will let you capture the results of reindexing into a local file called reindex.log (&UFD& is a reference to the current, or project, directory).

Code: Select all

DIVERT.OUT ON &UFD& reindex.log
DS.REINDEX ALL
DIVERT.OUT OFF
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
talk2shaanc
Charter Member
Charter Member
Posts: 199
Joined: Tue Jan 18, 2005 2:50 am
Location: India

Post by talk2shaanc »

Hey thnx,

I got that done, none of the users where "actually" accessing that project at that time. But one of the job was locked internally, due to which index rebuilding was failing. So i just cleaned up the resources and did it again.
Shantanu Choudhary
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

And... :?:

Can you now see the jobs OK?
Have you updated your administration documentation? :twisted:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply