What happens if you only stop and restart the DB2 services on W2K, rather
than rebooting the W2K server?
What happens if you stop and restart the DB2 and network services on the
AS400?
It would help to narrow down the qestion to whether it's DB2 or something
lower down.

"Asaf" <regadodli@hotmail.com> wrote in message
news:44e71ca0.0307171547.3124e453@posting.google.c om...
> Hi,
>
> I have a visual basic application on a W2k server that is using ADODB
> and iSeries driver to connect to DB2 on AS/400. Connection pooling is
> enabled on both ODBC manager and the VB code. it usually takes 0.5
> seconds to make a connection to DB2 however once in a week it starts
> picking up to 20, 30, 40 seconds and finally 300 seconds to open a
> connection!!! Once a connection is established, queries are coming
> back very quick. Only cure is to reboot the (w2k) machine... (this
> per se eliminates suspected network or AS400 potential causes). CPU
> and memory utilization during the slow responsiveness on both W2k and
> AS400 are very low.
>
> This happens on a mission critical system! Any help or hints will be
> highly appreciated
> thanks in advance
> Asaf.