Routines have disappeared

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
lh3
Participant
Posts: 8
Joined: Thu May 13, 2004 7:53 am
Location: Prague, Czech Rep.

Routines have disappeared

Post by lh3 »

Hello all,

We've met strange behaviour. Few weeks ago all DataStage routines (both standard and custom) have disappeared from repository on production server. It means we can't see them in Designer nor Manager. Only case when we are able to read them is when we open sequences where are some routines included. Then we see their code. Surprisingly our project is running without any problem so I suppose this is the problem of repository. But how this could be or how this could happen that's the question.

Any idea?

Thanks

Lubomir[size=9][/size]
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It could be a problem with indexing in the Repository; the clients use the indexes (particularly the CATEGORY index) to retrieve components for display.

At some time when there are no components open for editing in the project, use either the Administrator client Command window or a telnet session in the dssh environment to execute the command

Code: Select all

DS.REINDEX ALL
This will rebuild all the indexes in the Repository and may well render your routines visible again.

As to cause, there are many possible causes, some more likely than others, and which would take too long to canvas here.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
lh3
Participant
Posts: 8
Joined: Thu May 13, 2004 7:53 am
Location: Prague, Czech Rep.

Post by lh3 »

DS.REINDEX works perfectly.

Thanks

Lubomir
Post Reply