how to get session-id ?!

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 ~~

"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.

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 !!!

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.