Syssession information

Good morning, I am currently working on instances (11.70) that have a number of listeners. Is there a way to get the listener a client connected to something like the example below: $ onstat -c DBSEVERNAMEservinst1_str $ onstat -c DBSERVERALIAS servinst1_tcp,servinst1b_tcp,servinst1b_drd select username, connection_alias from sysmaster:syssessions; user connection_alias informix servinst1_str informix servinst1_str informix servinst1_tcp user1 servinst1_tcp user1 servinst1b_tcp user1 servinst1b_tcp user1 servinst1b_tcp user2 servinst1b_drd .. I thought that I could link with sysnetworkio to get the needed info, but to no avail. Thanks Kenneth

Ken: I don't think that information is available. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Mar 17, 2015 at 6:46 AM, KENNETH PENZA <kenneth.penza@gov.mt> wrote: > Good morning, > > I am currently working on instances (11.70) that have a number of > listeners. > Is there a way to get the listener a client connected to something like the > example below: > > $ onstat -c DBSEVERNAME> servinst1_str > $ onstat -c DBSERVERALIAS > servinst1_tcp,servinst1b_tcp,servinst1b_drd> > select username, connection_alias from sysmaster:syssessions;> > user connection_alias > informix servinst1_str > informix servinst1_str > informix servinst1_tcp > user1 servinst1_tcp > user1 servinst1b_tcp > user1 servinst1b_tcp > user1 servinst1b_tcp > user2 servinst1b_drd > ... > > I thought that I could link with sysnetworkio to get the needed info, but > to > no avail. > > Thanks > Kenneth > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec50fdfbb9c4b67051179d8ad

Art, Thanks a lot for your feedback. Regards Kenneth