Re: Configuring remote tcp connections.

Posted in 2005

Summary

Nuno Paquete asked how to configure NETTYPE for other connection types. Nilesh Ozarkar quoted the Administrator's Reference example with ipcshm and soctcp entries. Jonathan Leffler said IDS and XPS need only configuration, while SE and OnLine also need sqlexecd. Art S. Kagel said extra protocols require DBSERVERALIASES entries beyond DBSERVERNAME.

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

Topics: Server Administration, Networking & sqlhosts Configuration

Nilesh Ozarkar — Fri, 4 Nov 2005 14:52:08 -0600 — source: Usenet: comp.databases.informix

Hi, here is excerpt from "IDS Administrator's Reference Guide." ------- You can specify a NETTYPE parameter for each protocol that you want the database server to use. The following example illustrates NETTYPE parameters for two types of connections to the database server: a shared memory connection for local clients, and a network connection that uses sockets: NETTYPE ipcshm,3,,CPU NETTYPE soctcp,,20,NET The NETTYPE parameter for the shared-memory connection (ipcshm) specifies three poll threads to run in CPU virtual processors. The number of connections is not specified, so it is set to 50. The NETTYPE parameter for the sockets connection (soctcp) specifies that only 20 simultaneous connections are expected for this protocol and that one poll thread (because the number of poll threads is not specified) will run in a network virtual processor (in this case, NET). ------- For more details refer to NETTYPE configuration parameter in Admin guide. http://publib.boulder.ibm.com/epubs/pdf/25122680.pdf Regards, Nilesh -- Nilesh Ozarkar Informix Database Engineering, IBM Information Management Friday, November 04, 2005 2:28 PM To: informix-list@iiug.org cc: From: "Nuno Paquete" <nmp@ispgaya.pt> Subject: Re: Configuring remote tcp connections. Hi, I've got this line on my $ONCONFIG file: NETTYPE ipcshm,1,120,CPU # Configure Poll thread for nettype I need this line. How can I define other NETTYPE values? Can you show me an example of two distinct configurations? Regards, Nuno Paquete sending to informix-list

↪ replying to Nilesh Ozarkar

Nuno Paquete — 6 Nov 2005 10:38:38 -0800 — source: Usenet: comp.databases.informix

Hi, Thanks to all of you guys. Now I just have one more question: Do I have to install anything in the server so it can communicate using tcp connections, or I just need to change the configuration files? Best regards, Nuno Paquete

↪ replying to Nuno Paquete

Jonathan Leffler — Mon, 07 Nov 2005 03:46:36 GMT — source: Usenet: comp.databases.informix

Nuno Paquete wrote: > Thanks to all of you guys. Now I just have one more question: > Do I have to install anything in the server so it can communicate using > tcp connections, or I just need to change the configuration files? IDS and XPS - just configure. SE and OnLine - you must run sqlexecd too. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

↪ replying to Nuno Paquete

Art S. Kagel — Mon, 07 Nov 2005 13:14:28 -0500 — source: Usenet: comp.databases.informix

Nuno Paquete wrote: > Hi, > > Thanks to all of you guys. Now I just have one more question: > Do I have to install anything in the server so it can communicate using > tcp connections, or I just need to change the configuration files? > > Best regards, > Nuno Paquete > TO use multiple comm. protocols you must define a separate connection name for each additional protocol beyond the one used by the primary servername in the DBSERVERALIASES ONCONFIG parameter in addition to the primary name in DBSERVERNAME. Art S. Kagel

Glossary

onconfig