Professional Web Applications Themes

ADODB connection to AS400 via iSeries takes up to 300 seconds - IBM DB2

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 ...

  1. #1

    Default ADODB connection to AS400 via iSeries takes up to 300 seconds

    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.
    Asaf Guest

  2. #2

    Default Re: ADODB connection to AS400 via iSeries takes up to 300 seconds

    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" <regadodlihotmail.com> wrote in message
    news:44e71ca0.0307171547.3124e453posting.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.

    Mark Yudkin Guest

Similar Threads

  1. Can't conect to DB2 on iSeries (AS400)
    By dremmeister in forum Coldfusion Database Access
    Replies: 2
    Last Post: September 18th, 06:55 PM
  2. AS400 Connection problems - Configuring ports?
    By ZaneyFellow in forum Coldfusion Database Access
    Replies: 1
    Last Post: December 28th, 10:36 PM
  3. iSeries Connection
    By newmarx in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 19th, 08:16 PM
  4. Error Connection to AS400
    By mely_mel in forum Coldfusion Server Administration
    Replies: 0
    Last Post: July 15th, 08:45 PM
  5. ASP connection to DB2/AS400
    By mechweb in forum ASP
    Replies: 9
    Last Post: July 7th, 07:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139