How to Rebuild repository index using DS.REINDEX ALL

mekrreddy · Post by **mekrreddy** » Mon Feb 16, 2009 1:21 pm

Does anyone know how to rebuild the repository index by executing the DS.REINDEX ALL command from the Datastage shell? I do not have admin access

I get error while running the job which is moved from dev environment to test environment, which says "Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project (The connection is broken (81002))".

ray.wurlod · Post by **ray.wurlod** » Mon Feb 16, 2009 2:19 pm

By "I don't have admin access" do you mean that you do not have the Administrator client installed or that you do not have a login that is credentialled as a DataStage administrator?

You can open the Administrator client even though you are not a DataStage administrator, and the Command window is available to execute commands that do not require this authority. DS.REINDEX is one such command.

mekrreddy · Post by **mekrreddy** » Mon Feb 16, 2009 2:27 pm

I do not have login credentials as admin

chulett · Post by **chulett** » Mon Feb 16, 2009 2:40 pm

You don't need them for this - all you need is exclusive (and I do mean exclusive) access to the Project in question to run the command.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 16, 2009 2:42 pm

You would benefit by reading my entire post.

Premium membership is not expensive, at less than 30c per day. It is one of the ways that DSXchange is funded.

mekrreddy · Post by **mekrreddy** » Mon Feb 16, 2009 3:35 pm

Thank you Ray, got it.