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.