Releasing stuck jobs on designer?

PilotBaha · Post by **PilotBaha** » Tue Jan 13, 2009 12:04 pm

I remember using a UNIX command to release jobs being hung by the Datastage Designer but I cannot find it in my notes.. Can anyone send me the command?

Thanks,

Baha

narasimha · Post by **narasimha** » Tue Jan 13, 2009 12:17 pm

Hereyou go ...

chulett · Post by **chulett** » Tue Jan 13, 2009 12:43 pm

I don't believe that is valid (or prudent) to use with the 8.x release.

narasimha · Post by **narasimha** » Tue Jan 13, 2009 12:59 pm

Oops did not check the Version.. My bad.

kandyshandy · Post by **kandyshandy** » Tue Jan 13, 2009 1:53 pm

Log on to web console as ADMIN and then go to Administration -> Session Management -> Active sessions

See for your session and select it, click Disconnect option (on the right side)

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 2:45 pm

You actually need a combination of techniques; you need to know the session ID of the session that owns the lock, otherwise you don't know which session to release in the IS administrator.

lstsaur · Post by **lstsaur** » Tue Jan 13, 2009 3:26 pm

Baha,
For version 8, you can just delete the entry (locked job) in the XMETALOCKINFO table.

kandyshandy · Post by **kandyshandy** » Tue Jan 13, 2009 4:10 pm

Ray, If Baha had only one designer client session open, then there would be only one session in web console with his User name, type as DS Designer etc. So he/she could directly select that session and disconnect.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 5:28 pm

kandyshandy wrote:Ray, If Baha had only one designer client session open, then there would be only one session in web console with his User name, type as DS Designer etc. So he/she could directly select that session and disconnect.

Big If. We had no information as to whether or not that was the case. I have clients with as many as 75 developers; this is hardly ever the case with those!