Oninit cdi / Archive
Talk to an expert →

connection ?

Posted in 2008

Summary

Peter Logan asked how to tell whether a user is connected by shared memory or TCP/IP. Robert Roussey answered that onstat -g ntu shows sessions and how they are connected, and Peter confirmed this worked. Dominic Seah then asked why some sessions show ipcshm and others soctcp, and what to watch for performance-wise, pasting sample output. No reply to that follow-up.

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

Topics: Networking & sqlhosts Configuration

Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

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

↪ replying to Peter_Logan@spartanstores.com
Robert Roussey(IT) — — source: IIUG Forums & Mailing Lists

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

↪ replying to Robert Roussey(IT)
Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

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

↪ replying to Peter_Logan@spartanstores.com
Dominic Seah Chin Teck — — source: IIUG Forums & Mailing Lists

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

Related threads

Glossary