RE: jdbc and informix's NETTYPE parameter
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BF728D.5767C29A
Content-Type: text/plain;
charset="iso-8859-1"
You won't be able to use NETTYPE to limit the number of network connections.
According to the Administrator's Guide,
"For all net types other than ipcshm, the poll threads dynamically
reallocate resources to support more connections as needed."
When your 4th network user tries to connect, the engine simply allocates
more resources to handle the extra connections.
HTH,
Paul Mosser
-----Original Message-----
From: hash100@mail.eclipse.net [mailto:hash100@mail.eclipse.net]
Sent: Tuesday, February 08, 2000 2:14 PM
To: informix-list@iiug.org
Subject: jdbc and informix's NETTYPE parameter
Hi,
We use informix7.3 on Solaris2.6. Consider this example:
NETTYPE ipcshm,1,3,CPU # Configure poll thread(s) for nettype
NETTYPE tlitcp,1,3,NET # Configure poll thread(s) for nettype
Using this, if I bring up 3 isql sesssions and leave them up,then
I get error 25588 on 4th isql session. So the first line works as expected.
Now, I have a java server connecting to informix using jdbc.
I can bring up several servers simultaneously and each retains the
connection (ie. does not close connection during its life). They
connect to the informix using the standard URL format like:
jdbc:informix-sqli://ifmxserver.lan.company.com:2222/testdb:INFORMIXSERVER=i
fmxserver
I have a service defined at port 2222 that is an 'ontlitcp' service.
This should connect to informix using TCP so the 2nd NETTYPE line above
should limit me to run only three simultaneoulsy. But I can bring up more.
My intention is to limit my java servers using NETTYPE.
What is wrong here?
Please cc me in your reply if you can.
Thanks.
-AH
------_=_NextPart_001_01BF728D.5767C29A
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: jdbc and informix's NETTYPE parameter</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>You won't be able to use NETTYPE to limit the number =
of network connections. According to the Administrator's =
Guide,</FONT>
<BR><FONT SIZE=3D2>"For all net types other than ipcshm, the poll =
threads dynamically reallocate resources to support more connections as =
needed."</FONT></P>
<P><FONT SIZE=3D2>When your 4th network user tries to connect, the =
engine simply allocates more resources to handle the extra =
connections.</FONT></P>
<P><FONT SIZE=3D2>HTH,</FONT>
<BR><FONT SIZE=3D2>Paul Mosser</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: hash100@mail.eclipse.net [<A =
HREF=3D"mailto:hash100@mail.eclipse.net">mailto:hash100@mail.eclipse.net=
</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, February 08, 2000 2:14 PM</FONT>
<BR><FONT SIZE=3D2>To: informix-list@iiug.org</FONT>
<BR><FONT SIZE=3D2>Subject: jdbc and informix's NETTYPE =
parameter</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Hi,</FONT>
</P>
<P><FONT SIZE=3D2>We use informix7.3 on Solaris2.6. Consider this =
example:</FONT>
<BR><FONT =
SIZE=3D2>NETTYPE =
ipcshm,1,3,CPU # Configure poll thread(s) for nettype</FONT>
<BR><FONT =
SIZE=3D2>NETTYPE =
tlitcp,1,3,NET # Configure poll thread(s) for nettype</FONT>
</P>
<P><FONT SIZE=3D2>Using this, if I bring up 3 isql sesssions and leave =
them up,then</FONT>
<BR><FONT SIZE=3D2>I get error 25588 on 4th isql session. So the first =
line works as expected.</FONT>
</P>
<P><FONT SIZE=3D2>Now, I have a java server connecting to informix =
using jdbc. </FONT>
<BR><FONT SIZE=3D2>I can bring up several servers simultaneously and =
each retains the</FONT>
<BR><FONT SIZE=3D2>connection (ie. does not close connection during its =
life). They </FONT>
<BR><FONT SIZE=3D2>connect to the informix using the standard URL =
format like:</FONT>
</P>
<P><FONT =
SIZE=3D2>jdbc:informix-sqli://ifmxserver.lan.company.com:2222/testdb:INF=
ORMIXSERVER=3Difmxserver</FONT>
</P>
<P><FONT SIZE=3D2>I have a service defined at port 2222 that is an =
'ontlitcp' service.</FONT>
<BR><FONT SIZE=3D2>This should connect to informix using TCP so the 2nd =
NETTYPE line above </FONT>
<BR><FONT SIZE=3D2>should limit me to run only three simultaneoulsy. =
But I can bring up more.</FONT>
<BR><FONT SIZE=3D2>My intention is to limit my java servers using =
NETTYPE.</FONT>
</P>
<P><FONT SIZE=3D2>What is wrong here?</FONT>
<BR><FONT SIZE=3D2>Please cc me in your reply if you can.</FONT>
<BR><FONT SIZE=3D2>Thanks.</FONT>
<BR><FONT SIZE=3D2>-AH</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01BF728D.5767C29A--