Locks or process are not listing in Director, How to get all

[chanduch9]

Hi

When i open the Cleanup resources window in DS Director, it is not showing/listing any locks or process . Can you tell me how to get all those list.

One o fmy sequence got locked and prompting a message 'accessing by other user' , i checked it, no one opend the sequence, how to unlock this sequence?

[chulett]

Silly question, perhaps, but did you click on the 'Show all' radio buttons?

[chanduch9]

Silly question, perhaps, but did you click on the 'Show all' radio buttons? ...

I tried that option before i post it. I did all which we do usually, but i find this bit strange which i never face before.

[chulett]

I haven't either.

Is this a problem just for you or for everyone?

[chanduch9]

Yes, Same problem for all others also. None of us able to get the list.

Is this a problem with Indexing? should i try with DS.REINDEX ALL in Administrator?

Appreciate your quick response.

[chanduch9]

Hi All,

We bounced our PROD server and restarted.
Still Datastage director is not showing the list of Locks , processes in the 'Cleanup resources' window. ( I checked with Show All option also)

Same issue is not there if i log in DEV server.
(Our env, DS Server jobs 7.5.3.1 , Unix OS)

Any kind of suggesions are really helpfull.

[chulett]

No clue. Something must be different between the two environments, the hard part is going to be figuring out on your end what that difference is. Best suggestion would be to open a case with your official support provider, the ones being paid Big Money by your company for just this sort of thing.

And no, don't reindex for this.

[ray.wurlod]

It may be that there are no locks.

Open Administrator client Command window and execute LIST.READU command. This displays the contents of the local repository lock table.