I just move a database into production on 12.5.3. The database was in
production on NT 11.9.3 prior. I see these message periodically. Can
anyone tell me what causes these messages and if there is an issue I need to
address.

01:00000:00860:2005/03/04 10:59:56.16 kernel Cannot read, host process
disconnected: 471 spid: 860
00:00000:00056:2005/03/04 10:59:56.16 kernel Cannot read, host process
disconnected: 471 spid: 56
00:00000:00225:2005/03/04 10:59:56.16 kernel Cannot read, host process
disconnected: 471 spid: 225
01:00000:00900:2005/03/04 13:59:54.66 kernel Cannot read, host process
disconnected: spid: 900

On Fri, 04 Mar 2005 14:54:22 -0800, S. Rosenblum wrote:

This is the result of client apps disconnecting without closing the
connection to the database server. For example a windows client that is
shutdown without closing the apps, or some Java clients tend to generate
this message (I know I get this from WebObject apps).

You can in general ignore this message, though you may want to reduce the
"keepalive" parameter for your linux kernel so that these connections are
reaped fairly fast (by default I think they will hang around for 2 hours
or more before the database server realizes that the client side has gone
away).

Michael
--
Michael Peppler [TeamSybase] mpeppler (AT) peppler (DOT) org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html