connection ?

I'm trying to verify if a user is connected to the database by my shared memory connection ... is there a table or onstat that can give this to me. I've looked at the onstat -g env and that shows the proper INFORMIXSERVER, but I'm not sure if they connected that way or with the TCP/IP connection ... Thanks ....

"onstat -g ntu" shows sessions and how they are connected if you know the user's session id. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter_Logan@spartanstores.com Sent: Thursday, February 21, 2008 12:27 PM To: ids@iiug.org Subject: connection ? [11371] I'm trying to verify if a user is connected to the database by my shared memory connection ... is there a table or onstat that can give this to me. I've looked at the onstat -g env and that shows the proper INFORMIXSERVER, but I'm not sure if they connected that way or with the TCP/IP connection ... Thanks .... ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

Perfect ... thanks .... "Robert Roussey(IT)" <Robert.Roussey@SpiritAir.com> Sent by: ids-bounces@iiug.org 02/21/2008 12:36 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: connection ? [11372] "onstat -g ntu" shows sessions and how they are connected if you know the user's session id. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter_Logan@spartanstores.com Sent: Thursday, February 21, 2008 12:27 PM To: ids@iiug.org Subject: connection ? [11371] I'm trying to verify if a user is connected to the database by my shared memory connection ... is there a table or onstat that can give this to me. I've looked at the onstat -g env and that shows the proper INFORMIXSERVER, but I'm not sure if they connected that way or with the TCP/IP connection ... Thanks .... ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

Hi, Just wondering why some showing ipcshm and some showing soctcp. Is there anything that we can look out for in terms of a performance perspective from running this command ? How would you use this command for usually ? Thanks. -------------------------------------------------------------------------------- --------------------------- 27c765858 ipcshm sqlexec 173226 0 0 7860 9396 -1714/ 0 0/ 0 0/ 0 27ccbfc68 ipcshm sqlexec 173222 0 0 7331 8951 -705/ 0 0/ 0 0/ 0 2e22f34e0 ipcshm sqlexec 173210 0 0 30429 43990 -4775/ 0 0/ 0 0/ 0 27d97d570 ipcshm ontape 173194 0 0 267621 267624 -24181/ 0 0/ 0 0/ 0 27ee0f050 ipcshm sqlexec 173179 0 0 65054 90720 -10665/ 0 0/ 0 0/ 0 27e027050 soctcp sqlexec 173129 75 5 176026 181227 1/ 3 0/ 1 0/ 0 27cfcb050 soctcp sqlexec 173037 45 5 196697 215797 0/ 8 0/ 1 0/ 0 27bac6c40 soctcp sqlexec 173026 7 5 104652 109700 0/ 2 1/ 1 0/ 0 2d2ee54b8 soctcp sqlexec 172949 15 5 275748 285683 0/ 8 1/ 1 0/ 0 2d98f1d30 soctcp sqlexec 172939 22 5 134460 141817 0/ 4 1/ 1 0/ 0 27e91cd60 ipcshm ontape 172926 0 0 22 25 -13/ 0 0/ 0 0/ 0 Best Regards, Dominic Seah 64616826 "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com> Sent by: ids-bounces@iiug.org 22-Feb-08 02:17 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: connection ? [11373] Perfect ... thanks .... "Robert Roussey(IT)" <Robert.Roussey@SpiritAir.com> Sent by: ids-bounces@iiug.org 02/21/2008 12:36 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: connection ? [11372] "onstat -g ntu" shows sessions and how they are connected if you know the user's session id. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter_Logan@spartanstores.com Sent: Thursday, February 21, 2008 12:27 PM To: ids@iiug.org Subject: connection ? [11371] I'm trying to verify if a user is connected to the database by my shared memory connection ... is there a table or onstat that can give this to me. I've looked at the onstat -g env and that shows the proper INFORMIXSERVER, but I'm not sure if they connected that way or with the TCP/IP connection ... Thanks .... ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!