Dropped Sessions Pervasive v7
- From: "JBreits" <jbreits@xxxxxxxxx>
- Date: 29 Jun 2005 07:09:54 -0700
We are using Pervasive v7 with a 3rd party software. We can't upgrade
Pervasive as the 3rd party software doesn't support it. We are using
TCP/IP protocol to connect to a remote database. Approx 100 clients
are using this software (not necessarily all at once).
The problem that we are having is that the client sessions appear to be
being dropped. Looking in to the PVSW.LOG file on a client machine
shows lots of status 3111, 3112, and 10054 messages.
I have looked these up and it appears that they are related to
connections to the database server being dropped. I have talked to our
IT dept and they claim that the network is just fine (of course). I
even had them install a sniffer on the client and on the server to
monitor transmissions. And for the 3 weeks that they monitored,
everything went smoothly (of course)!!! So I got no help from them.
It does seem that the problems coincide with periods of high network
usage, mostly when our IT dept is pushing out updates to computers.
They generally do these updates overnight and that's when the problems
usually occurr. We have batch processes that run overnight and it is a
real pain when they don't work.
Lately, these "disconnects" have been occurring pretty much nightly.
This coincides with the fact that IT is pushing out updates to McAffee
v8 and Win XP SP2. Factor in the 5000+ computers that they are
updating, and that makes for some heavy network traffic that could go
on for weeks.
I guess my main question is if there is a way to set Pervasive's
Timeout value so it waits longer before deciding the connection was
dropped? Or is there a way to set Pervasive to use retries?
Checking the Pervasive setup on my local machine, I noticed TCP/IP
Timeout value under Communications Requester. Could that be anything
useful? It is currently set to 15.
Server is Win2003 Server. Dual Intel Xeon processors. 6GB RAM.
Clients are XP, P4's 256-512MB RAM.
Thanks,
JBreits
.
- Follow-Ups:
- Re: Dropped Sessions Pervasive v7
- From: Bill Bach
- Re: Dropped Sessions Pervasive v7
- Prev by Date: DataExchange - anyone using this product ?
- Next by Date: Re: NTDBSMGR Handles are going crazy
- Previous by thread: DataExchange - anyone using this product ?
- Next by thread: Re: Dropped Sessions Pervasive v7
- Index(es):
Relevant Pages
|