Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
satish_valavala
Participant
Posts: 123 Joined: Wed May 18, 2005 7:41 am
Location: USA
Post
by satish_valavala » Thu Jul 17, 2008 8:25 am
Not able to open the job. It got locked by a user. We have tried to look for the lock every where (DS Director, Unix processess, Websphere session through console). Is there any way to look for inactive/lingering sessions in websphere console.
Here is the error,
Unable to open the job
The Job 'myjob' is locked by used 'abc' (Session ID 'A7C2F32E-E2A6-3C84-1234-EBEC56D1A5D1')
Regards
VS
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Jul 17, 2008 9:57 am
If you look at session management in the websphere admin window you should find this session id.
satish_valavala
Participant
Posts: 123 Joined: Wed May 18, 2005 7:41 am
Location: USA
Post
by satish_valavala » Thu Jul 17, 2008 10:42 am
I didn't find the session ID in iis console---->Admin---->Session Mgmt--->Active Sessions.
We have a session timeout property - 1800 secs, but this session is hanging since last 12+ Hrs
Is there any way to see the inactive/hanging sessions in Websphere.
Regards
VS
lstsaur
Participant
Posts: 1139 Joined: Thu Oct 21, 2004 9:59 pm
Post
by lstsaur » Thu Jul 17, 2008 11:38 am
You can find that info. in the table XMETALOCKINFO.
satish_valavala
Participant
Posts: 123 Joined: Wed May 18, 2005 7:41 am
Location: USA
Post
by satish_valavala » Tue Jul 29, 2008 9:38 pm
Yes, XMETALOCKINFO table has all these hanging session info. We got a script from IBM support to clear these kind of locks from that XMETA table.
It is RESOLVED.
Thanks
Regards
VS
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Jul 29, 2008 11:29 pm
No it isn't, because you have not clicked the button at the top the thread that would mark it as Resolved.
Any chance of sharing the script?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.