Not able find the Websphere Session ID

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

Post Reply
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

Not able find the Websphere Session ID

Post by satish_valavala »

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 »

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 »

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 »

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 »

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 »

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.
Post Reply