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
DataStage jobs are not visible in the Designer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore
SELECT COUNT(*) FROM DS_JOBOBJECTS not working
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
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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore
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?sumesh.abraham wrote:DS.REINDEX ALL command can be executed now as per the procedure stated by you.
Oh well, at least you can't make your problem any worse.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: