Page 1 of 1
How to Rebuild repository index using DS.REINDEX ALL
Posted: Mon Feb 16, 2009 1:21 pm
by mekrreddy
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))".
Posted: Mon Feb 16, 2009 2:19 pm
by ray.wurlod
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.
Posted: Mon Feb 16, 2009 2:27 pm
by mekrreddy
I do not have login credentials as admin
Posted: Mon Feb 16, 2009 2:40 pm
by chulett
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.
Posted: Mon Feb 16, 2009 2:42 pm
by ray.wurlod
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.
Posted: Mon Feb 16, 2009 3:35 pm
by mekrreddy
Thank you Ray, got it.