If the client dies, the server will detect this. This is documented in the
Troubleshooting Guide using the following words:
<quote>
DB2 uses TCP/IP's connection KEEPALIVE option to detect if there is a
connection failure. This option transmits a message periodically to
determine if the partner is still alive. If the partner fails to respond to
this message, the connection is considered to be broken, and an error is
returned.
A client may appear to be suspended if the KEEPALIVE settings on the client
have been set to check TCP/IP connections infrequently and the server has
gone down.
</quote>
The discussion continues with information on how to alter the keepalive
setting. There is also information in the Administration Guide.
"the6campbells" <th***********@hotmail.com> wrote in message
news:db**************************@posting.google.c om...
Vendors such as ORACLE document how they support the server being
configured to provide dead connection detection. I see no
documentation in the IBM manuals or support site notes that suggest
that DB2 supports this. Do any of the DB2 editions support this and
how to you enable it?
Note: I am not talking about idle connection management