unable to see the jobs in Repository

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sunshine
Participant
Posts: 61
Joined: Wed Jan 04, 2006 10:24 am

unable to see the jobs in Repository

Post by sunshine »

Hi,

I executed DS.REINDEX ALL from command line from DataStage Administrator.

when i open Designer,after executing DS.REINDEX ALL command,

I am UNABLE to see the jobs in Repository Pallette..
Even when i open the Director,its not displaying any jobs..

strange problem.. :(

I never faced such a type of problem before..


Looking forward for your reply...


Regards
sunshine
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I've seen that happen if you are not alone in the Project. Are there any other users or processes accessing that Project? You may need to kill off any 'leftovers' from other folks and try it again.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sunshine
Participant
Posts: 61
Joined: Wed Jan 04, 2006 10:24 am

Post by sunshine »

[quote="chulett"]I've seen that happen if you are not alone in the Project. Are there [b]any[/b] other users or processes accessing that Project? You may need to kill off any 'leftovers' from other folks and try it again.[/quote]

Hi,

I am alone in the project.
i logged as Administrator.

i restarted the system,but still arise same problem.

but i am sure this happened after executing DS.REindex ALL from Administrator command button... :(

do you have any idea?

Looking forward for your reply,

Regards
sunshine
tombastian
Premium Member
Premium Member
Posts: 41
Joined: Fri Jun 04, 2004 5:52 am
Location: Bangalore

Post by tombastian »

It happens this way when any of the DataStage Jobs are open in Designer during the REINDEXing process. Make sure that none of the jobs are opened (locked status) before executing this command. You can execute this command once again after making sure that none of the jobs are on locked state.
sunshine
Participant
Posts: 61
Joined: Wed Jan 04, 2006 10:24 am

Post by sunshine »

[quote="tombastian"]It happens this way when any of the DataStage Jobs are open in Designer during the REINDEXing process. Make sure that none of the jobs are opened (locked status) before executing this command. You can execute this command once again after making sure that none of the jobs are on locked state.[/quote]


yes,i done in the same way as u said.
i restarted the system and stop/start all datastage services online.
but still same problem.

have you tried using DS.REINDEX ALL in Command?

I wonder why i cant see any jobs,after using REINDEX..



Looking forward for your reply,

Regards
sunshine
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Post by rasi »

Do you have backup of your projects?
Regards
Siva

Listening to the Learned

"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's probably OK, and you are likely to recover if you DS.REINDEX ALL when no-one else is using the project.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Exactly. As I tried to say earlier on, all it takes is one stray connection or lock to have a REINDEX make a Project look empty. Been there, done that. :wink:

Try again. Use LIST.READU to ensure there are no stray locks on your objects in the repository before you do so and UNLOCK any that still remain. A search of the forum will turn up syntax and examples of using both.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply