Page 1 of 1
Releasing stuck jobs on designer?
Posted: Tue Jan 13, 2009 12:04 pm
by PilotBaha
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
Posted: Tue Jan 13, 2009 12:17 pm
by narasimha
Posted: Tue Jan 13, 2009 12:43 pm
by chulett
I don't believe that is valid (or prudent) to use with the 8.x release.
Posted: Tue Jan 13, 2009 12:59 pm
by narasimha
Oops did not check the Version.. My bad.
Posted: Tue Jan 13, 2009 1:53 pm
by kandyshandy
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)
Posted: Tue Jan 13, 2009 2:45 pm
by ray.wurlod
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.
Posted: Tue Jan 13, 2009 3:26 pm
by lstsaur
Baha,
For version 8, you can just delete the entry (locked job) in the XMETALOCKINFO table.
Posted: Tue Jan 13, 2009 4:10 pm
by kandyshandy
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.
Posted: Tue Jan 13, 2009 5:28 pm
by ray.wurlod
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!