Oninit cdi / Archive
Talk to an expert →

how to get session-id ?!

Posted in 2010

Summary

Mars Chen, running two IDS 11.50.UC6 servers, wanted to match a session on a remote server (from a distributed query like select from stores@if88:customer) to the originating session on the local server. Paul Chin suggested onstat -u and onstat -g sql; Mars said that does not help with thousands of sessions. A poster suggested onstat -g ses SESSIONID shows the connection origin, untested. No confirmed solution.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Server Administration

MARS CHEN — — source: IIUG Forums & Mailing Lists

Dear All... I've 2 IDS 11.50.uc6 , say if66 and if88 , run dbaccess in db1@if66 ,and run sql :"select * from stores@if88:customer" , now I get the session-id of if66 is 114 , and get the session-id of if88 is 40 , but I don't know how to identify the linkage of these 2 sessions , suppose I am watching if88 , I am interested to know which session-id of if66 to produce this session 40 , what command or sql I can use so that I will get the actual session 114 of if66 is exactly the session to produce session 40 of if88 .... Forgive me for my poor english ~~

↪ replying to MARS CHEN
Chin, Paul (TSG-OSDO) — — source: IIUG Forums & Mailing Lists

"Onstat -u" will show you the session, user name name and the terminal name. "onstat -g sql <session id)" will show you the sql statement. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MARS CHEN Sent: Wednesday, 7 April 2010 7:39 PM To: ids@iiug.org Subject: how to get session-id ?! [19526] Dear All... I've 2 IDS 11.50.uc6 , say if66 and if88 , run dbaccess in db1@if66 ,and run sql :"select * from stores@if88:customer" , now I get the session-id of if66 is 114 , and get the session-id of if88 is 40 , but I don't know how to identify the linkage of these 2 sessions , suppose I am watching if88 , I am interested to know which session-id of if66 to produce this session 40 , what command or sql I can use so that I will get the actual session 114 of if66 is exactly the session to produce session 40 of if88 .... Forgive me for my poor english ~~ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Chin, Paul (TSG-OSDO)
MARS CHEN — — source: IIUG Forums & Mailing Lists

If I have thousands of sessions in if66 , I don't know which session connect if88 through session 40 , All I know is that session 40 of if88 is the session which application connect to if66 and then run sql like "select * from stores@if88:customer" , I want to find out which session of if66 doing this !!!

↪ replying to MARS CHEN
rroussey@comcast.net — — source: IIUG Forums & Mailing Lists

I think "onstat -g ses SESSIONID" will include the origination of the connection. You can just do "onstat - g ses" and it will show the abbreviated list for all connections in the instance. (I don't have a working instance available to me at the moment). Bob ----- Original Message ----- From: "MARS CHEN" <mars@jsun.com> To: ids@iiug.org Sent: Wednesday, April 7, 2010 6:03:33 AM GMT -05:00 US/Canada Eastern Subject: Re: RE: how to get session-id ?! [19530] If I have thousands of sessions in if66 , I don't know which session connect if88 through session 40 , All I know is that session 40 of if88 is the session which application connect to if66 and then run sql like "select * from stores@if88:customer" , I want to find out which session of if66 doing this !!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary