Re: Index Size, On Table, Off Table, Reindexing Online......
RoB, I'm not sure if this will help you, but TCP_KEEPALIVE might allow you to maintain client connections. IBM has documentation related to it at the following URL: http://publib.boulder.ibm.com/infocenter/pseries/v5r3/index.jsp?topic=/c om.ibm.aix.fastconnect/doc/fastcon/configparams.htm Let us know if this resolves your problem. Mike Badar ESRI Professional Services 1 International Court Broomfield, CO 80021-3200 303-449-7779 mbadar@esri.com www.esri.com > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of Roy Mercer > Sent: Thursday, September 21, 2006 9:43 AM > To: informix-list@iiug.org > Subject: Re: -1803 Connection does not exist. > > We had this same issue, but the application server was a Windows XP > desktop. > After applying SP2, when the user would not use the connection they > would get a > -1803 and/or a database not selected (can't remember the > error number). > It turned out to be a network setting within windows. It may have > been the windows firewall, not sure. Check out your network > settings on the application server, there may be something killing the > network connection when there is no activity. > Sorry I don't know more details, but you are on the correct path. > > Thanks > > > > RoB wrote: > > Hi group, > > > > IHAC that is getting the following error message in their > application > > server logs periodically from two different application > servers on two > > different machines: > > > > -1803 Connection does not exist. > > > > The application servers work but this is causing some > problems when it > > occurs. > > > > Database server: > > > > IDS 10.00.FC5 > > AIX 5.3 (seen on both 5300-04 and 5300-05) > > > > Application servers: > > > > Red Hat Enterprise Linux ES release 4 (Nahant Update 3) > > 2.6.9-34.ELsmp > > > > > > On the database server machine there is nothing in the > online.log at, > > and around the time of the occurrence and the server has not reached > > the maximum amount of user connections. > > > > All the machines are on the same network so there are no firewalls > > messing things up. > > > > The app servers has a pool of connections open against the database > > server and since this is still in testing I assume that not > all of them > > are actually used. > > The problem could be a TCP timeout issue on the AIX box as > this hasn't > > been seen on systems with the same setup with only Linux operating > > systems. The AIX network settings (man no) are all set to > their default > > settings and there is nothing relevant in the OS event log. > > > > Has anyone had any experience with this type of problem > before? Would > > changing any network settings on the AIX box make any difference? > > > > /RoB