DSXchange

In a particular project,no jobs are visible in the repository of DataStage designer. Please let me know the cause for this abnormal behaviour.

Thanks in advance
Sumesh

More than likely, the repository indexes are corrupt. Do an exact search of the site for DS.REINDEX ALL for the procedure to follow.

Thanks for the info. Before performing DS.REINDEX ALL,i tried executing the command SELECT COUNT(*) FROM DS_JOBOBJECTS in the DS Administrator. It shows SQL+. Similiar is the result for SELECT * FROM DS_JOBS as well. Can i close all the sessions and execute DS.REINDEX ALL now.

Thanks
Sumesh

It shows "SQL+" because it is asking for the rest of your statement... you need a semi-colon at the end of the statement to get it to actually run.

You need to ensure ALL connections are closed before running the reindex command or you are wasting your time. Best to do this by shutting the DataStage server down, waiting for all ports to clear, then restarting it... after that, do the reindex. Do you have an ETL 'admin' there that can help you will all that?

Thanks for the info. The SELECT statement works fine now. DS.REINDEX ALL command can be executed now as per the procedure stated by you.

Thanks
Sumesh

sumesh.abraham wrote:DS.REINDEX ALL command can be executed now as per the procedure stated by you.

You seem to have skipped all the other parts of what little of a 'procedure as stated by me' exists in this thread. Where did I tell you to query anything?

Oh well, at least you can't make your problem any worse.

Wanna bet? DS.REINDEX ALL with connected users can make things worse - you can guarantee that the index is emptied!

Only reason I said that was because it was already empty.