Unlock jobs

RAI ROUSES · Post by **RAI ROUSES** » Mon Dec 28, 2009 9:19 pm

Hi,
We are working with datastage version 8 in a sun machine. We have several job sever running and same parallel jobs. We have same problems of connections with the server that cause the lock of the job s.

What is the best way to unlock it ?

In version 7 we do it in director, now for server and parallel jobs we can do the same ?
Or we should unlock it in the web page of information server ?

merci

Rai

ray.wurlod · Post by **ray.wurlod** » Mon Dec 28, 2009 9:51 pm

Unlock it in Director (Cleanup Resources) if it's there, otherwise unlock it by disconnecting the Information Server session using Web Console for Information Server.

RAI ROUSES · Post by **RAI ROUSES** » Tue Dec 29, 2009 2:59 am

Hi,
I can't do in the Director, because the option Cleanup Resources is not active in the projects.

If i disconnect the Information Server session using Web Console for
Information Server, i will disconnect all sessions, correct ?

And i only want to unlock same jobs from same sessions.
How it's possible to do that ?

merci

Rai

vinsashi · Post by **vinsashi** » Tue Dec 29, 2009 4:05 am

Hi,
In Datastage Administrator select project and click on properties under general tab you will get Enable job administration in Director.If you enable that you will get Cleanup resources active in Director.(after enable close once director and open)

Thanks
vin..

ray.wurlod · Post by **ray.wurlod** » Tue Dec 29, 2009 4:47 am

RAI ROUSES wrote:If i disconnect the Information Server session using Web Console for Information Server, i will disconnect all sessions, correct ?

Not correct. You can identify the particular session. The easiest way it to try to open the locked job, and you will learn the id of the session that owns the lock. Find this session in the active sessions window and disconnect just that session.