Question about Keep-Alive Option
Posted in 2006
Topics: Networking & sqlhosts Configuration, Platform-Specific Issues, Internationalization & Character Sets
I copied a paragraph from Admin Guideas following,
IBM Informix Dynamic Server Administrator's Guide
Previous Page | Next Page | Index The Database Server >
Client/Server Communications > The sqlhosts Information >
Connectivity Information
Keep-Alive Option
.......................
When a connected client and server are not exchanging data and the
keep-alive option is enabled, the network service checks the
connection periodically. If the receiving end of the connection does
not respond within the time specified by the parameters of your
operating system, the network service immediately detects the broken
connection and frees resources.
......
My question is,
(1) in above statement "...specified by the parameters of your
operating system...", what is the names of the parameters in the OS ?
(2) "network service" is a process in Informix or in our OS?
Program Name: onstat
Build Version: 10.00.UC4
Build Number: N204
Build Host: ibm6c1b
Build OS: AIX 5.2
Build Date: Fri Nov 18 23:37:26 CST 2005
GLS Version: glslib-4.00.UC7
fqu@dolly $
Thanks,
Quman
AIX 5.3
tcp_keepcnt = 8
tcp_keepidle = 14400
tcp_keepinit = 150
tcp_keepintvl = 150
These are all in seconds 14400 seconds = 240 Minutes = 4 Hours
For more information `man no`
I found that following on IBM's site for another production:
<http://publib.boulder.ibm.com/infocenter/printer/v1r1/index.jsp?topic=/com.ibm.
printers.ipmaix/com.ibm.printers.aixprocedures/iprx2mst26.htm>
The following link will give other "OS's". Kernel values and commands;
<http://www.sybase.com/detail?id=611>
Informix or IIUG needs a page similar... Information like this can be
so valuable when tuning.
On 8/31/06, Quman <yquman@gmail.com> wrote:
>
> I copied a paragraph from Admin Guideas following,
>
> IBM Informix Dynamic Server Administrator's Guide
> Previous Page | Next Page | Index The Database Server >
> Client/Server Communications > The sqlhosts Information >
> Connectivity Information
>
> Keep-Alive Option
>
> ........................
> When a connected client and server are not exchanging data and the
> keep-alive option is enabled, the network service checks the
> connection periodically. If the receiving end of the connection does
> not respond within the time specified by the parameters of your
> operating system, the network service immediately detects the broken
> connection and frees resources.
> .......
>
> My question is,
> (1) in above statement "...specified by the parameters of your
> operating system...", what is the names of the parameters in the OS ?
>
> (2) "network service" is a process in Informix or in our OS?
>
> Program Name: onstat
> Build Version: 10.00.UC4
> Build Number: N204
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Fri Nov 18 23:37:26 CST 2005
> GLS Version: glslib-4.00.UC7
> fqu@dolly $
>
> Thanks,
> Quman
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Just to correct u a bit .. 14400 is not in seconds but in 1/2 seconds .=
..
so actually its 2 hours and not 4 hours.
Thanx much,
Rajib Sarkar
Sr. Technical Analyst
DB2 UDB RPD Team
IBM Data Management Group
T/L : 667-2100
http://www.ibm.com/software/data/db2/udb/support/
From his neck down a man is worth a couple of dollars a day, from his n=
eck
up he is worth anything that his brain can produce. -- T. Edison
=
"Eric Rowell" =
<erowell@gmail.co =
m> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: Question about Keep-Alive =
08/31/2006 10:55 Option [7377] =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
AIX 5.3
tcp_keepcnt =3D 8
tcp_keepidle =3D 14400
tcp_keepinit =3D 150
tcp_keepintvl =3D 150
These are all in seconds 14400 seconds =3D 240 Minutes =3D 4 Hours
For more information `man no`
I found that following on IBM's site for another production:
<
http://publib.boulder.ibm.com/infocenter/printer/v1r1/index.jsp?topic=3D=
/com.ibm.printers.ipmaix/com.ibm.printers.aixprocedures/iprx2mst26.htm
>
The following link will give other "OS's". Kernel values and commands;
<http://www.sybase.com/detail?id=3D611>
Informix or IIUG needs a page similar... Information like this can be
so valuable when tuning.
On 8/31/06, Quman <yquman@gmail.com> wrote:
>
> I copied a paragraph from Admin Guideas following,
>
> IBM Informix Dynamic Server Administrator's Guide
> Previous Page | Next Page | Index The Database Server >
> Client/Server Communications > The sqlhosts Information >
> Connectivity Information
>
> Keep-Alive Option
>
> ........................
> When a connected client and server are not exchanging data and the
> keep-alive option is enabled, the network service checks the
> connection periodically. If the receiving end of the connection does
> not respond within the time specified by the parameters of your
> operating system, the network service immediately detects the broken
> connection and frees resources.
> .......
>
> My question is,
> (1) in above statement "...specified by the parameters of your
> operating system...", what is the names of the parameters in the OS ?=
>
> (2) "network service" is a process in Informix or in our OS?
>
> Program Name: onstat
> Build Version: 10.00.UC4
> Build Number: N204
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Fri Nov 18 23:37:26 CST 2005
> GLS Version: glslib-4.00.UC7
> fqu@dolly $
>
> Thanks,
> Quman
>
>
>
***********************************************************************=
********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Hi,
for the first question you better ask some "OS buffs".
Last time I checked on these parameters was more than 6
years ago ...
[ Usually there are two parameters to it:
- the initial timeout, default value is often 2 hours,
- the timeout for repeated attempts, default is often 1 minute (I
think).
After the initial timeout, 10 attempts are made to get a response
from the connected counterpart. If there is still no response after
these 10 attempts, then the connection is considered dead.
TCP will close the connection. With that the overall time for most
default configurations is 2 hours and 10 minutes.
Since the TCP implementation usually is part of the OS,
specifics (parameter names, default values, etc.) may vary
among different OSs.
]
> (2) "network service" is a process in Informix or in our OS?
Hmm. It is not a process in the sense of a process with
a process ID running on a UNIX system. That means you will
not find anything using the "ps" system utility.
This is a "service" in the sense of a functionality implemented
in the TCP layer of the network layers (see the 7 layer
OSI model). Therefore the functionality is transparently used by
the process that has an open TCP/IP connection.
While in general the configuration of the TCP Keep-Alive is
done in the OS and usually for the whole UNIX system
(hence often via kernel parameters), the functionality is used
in individual processes that have TCP/IP network connections.
Usually the application does not even have to know about
this TCP Keep-Alive thing, because it is implemented inside
the TCP network layer.
You can read more about TCP Keep-Alive in books
like Steven's "Programming in the UNIX Environment".
I hope this makes things a bit clearer.
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
Informix URLs list: http://home.arcor.de/mfu1/informix/urls.html
IBM Information On Demand Global Conference
October 15-20, 2006, Anaheim, California
see http://www.ibm.com/events/informationondemand
ids-bounces@iiug.org wrote on 31.08.2006 18:46:48:
>
> I copied a paragraph from Admin Guideas following,
>
> IBM Informix Dynamic Server Administrator's Guide
> Previous Page | Next Page | Index The Database Server >
> Client/Server Communications > The sqlhosts Information >
> Connectivity Information
>
> Keep-Alive Option
>
> ........................
> When a connected client and server are not exchanging data and the
> keep-alive option is enabled, the network service checks the
> connection periodically. If the receiving end of the connection does
> not respond within the time specified by the parameters of your
> operating system, the network service immediately detects the broken
> connection and frees resources.
> .......
>
> My question is,
> (1) in above statement "...specified by the parameters of your
> operating system...", what is the names of the parameters in the OS ?
>
> (2) "network service" is a process in Informix or in our OS?
>
> Program Name: onstat
> Build Version: 10.00.UC4
> Build Number: N204
> Build Host: ibm6c1b
> Build OS: AIX 5.2
> Build Date: Fri Nov 18 23:37:26 CST 2005
> GLS Version: glslib-4.00.UC7
> fqu@dolly $
>
> Thanks,
> Quman
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.