Rebuilding DataStage repository indices.

anil411 · Post by **anil411** » Thu Dec 01, 2005 4:46 pm

Please guide me how to reindex DataStage repository. In the forum, I have seen, it can be done by running DS.REINDEX ALL but I don't know, where to run this command. I tried searching this in DS server under various directories but could find it.

I am using DataStage 7.5. In earlier version there was an option to do Project Cleanup in Administrator but now I don't see that.

Thanks,

Anil

Bala R · Post by **Bala R** » Thu Dec 01, 2005 5:24 pm

Log into the DataStage administrator, go to the Projects tab and select the project and click on the 'Command' button. In the command editor, type your basic command. HTH.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 01, 2005 11:05 pm

You really should leave the indexes alone unless you have reason to believe they need rebuilding.

anil411 · Post by **anil411** » Fri Dec 02, 2005 9:46 am

ray.wurlod wrote:You really should leave the indexes alone unless you have reason to believe they need rebuilding.

Ray, when I try to open a job in desinger, I get msg "This item has no design time information". I can run the job thru director but can not edit in designer. Please suggest, if I need to do anything else. Thanks.

chulett · Post by **chulett** » Fri Dec 02, 2005 9:58 am

More information, please. One job? All jobs? If you are 'releasing' jobs and the job in question is one that has been released, this is the expected behaviour.

Any idea how it got in this state?

anil411 · Post by **anil411** » Fri Dec 02, 2005 10:27 am

chulett wrote:More information, please. One job? All jobs? If you are 'releasing' jobs and the job in question is one that has been released, this is the expected behaviour.

Any idea how it got in this state?

I have not released the jobs yet. This is happening with only this job. All other jobs are running good. Also there is a sequence that is running few jobs. It runs all the jobs fine and I get the expected results. In the log in director, I get msg saying "Job control process (pid 8128) has failed".

ray.wurlod · Post by **ray.wurlod** » Fri Dec 02, 2005 4:16 pm

That message has nothing whatsoever to do with indexes. It relates to the fact that the design-time information is missing. This can come about, for example, by exporting only the job executable - not the job design. It can also result from partial deletion of the job design.

You need to establish what has happened. If you exported the job from a development system, do so again, compiling the job first, and making sure that you include the job design itself.

(Technically, the error message indicates that the ROOT record for the job is missing from DS_JOBOBJECTS. However, there are no utilities for re-building a ROOT record, so let's not go there.)