Professional Web Applications Themes

Linux RH8 db2 8.1 fp3 jcc connection randomly lagging when connecting other server than localhost - IBM DB2

I'm running my application on two separate RH8 linux bokses using Jboss 3.0.7 on the appserver and db2 8.1 fp3 on the db server. I am also running db2 8.1 fp2 on my appserver which seems to be working perfectly fine towards the same apps. My problem is that randomly the connection seems to stop up for 10-20 seconds before it continues. I also get the following error in my server.log file (jboss)2003-09-12 15:04:47,498 ERROR [STDERR] -99999 .. And it seems to occur approx. at the same time as the server hangs. There are no error messages in the db2diag.log ...

  1. #1

    Default Linux RH8 db2 8.1 fp3 jcc connection randomly lagging when connecting other server than localhost

    I'm running my application on two separate RH8 linux bokses using Jboss
    3.0.7 on the appserver and db2 8.1 fp3 on the db server.

    I am also running db2 8.1 fp2 on my appserver which seems to be working
    perfectly fine towards the same apps.

    My problem is that randomly the connection seems to stop up for 10-20
    seconds before it continues. I also get the following error in my server.log
    file
    (jboss)2003-09-12 15:04:47,498 ERROR [STDERR] -99999
    .. And it seems to occur approx. at the same time as the server hangs. There
    are no error messages in the db2diag.log files.

    It is really strange that this only fails when accessing the remote server.
    I am using the latest fp3 jcc driver to connect both locally and to the
    remote db server.

    The databases are exactly the same since I am using a restored db on the
    remote host. The instances on both servers have been set up with the same
    parameters, as well as the databases.

    I do not reakon this to be a jboss problem, as it works fine with the local
    databases.

    If this is a fp3 problem is the solution to reinstall db2 with fp2?

    Hope someone out there has an answer.
    I would be truly greatful.

    regards
    Thomas Sigdestad


    Thomas Sigdestad Guest

  2. #2

    Default Re: Linux RH8 db2 8.1 fp3 jcc connection randomly lagging when connecting other server than localhost

    If you're using datasources to connect, i suggest you use the trace
    properties
    (url/datasource properties)
    See Taking a Trace with the Universal JDBC Driver
    [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url]

    There is also a tool called db2drdat (DRDA Trace) that could help you see
    what happens.
    (os command line tool)

    To get mode output in the db2diag.log file, you can set db2 Diaglevel to 4
    (db2 update dbm cfg using diaglevel 4)

    Are you using the driver with type=4 or ?? (default is 2)
    (setDriverType())
    This would tell us if networking problems is a possibility.

    When it hangs, you can also see if you get locking problems using
    db2 get snapshot for locks ....

    Any Jboss logs information available?


    PM


    "Thomas Sigdestad" <_delete_tsienonic.com> a écrit dans le message de
    news:3f61cab6$1news.wineasy.se...
    > I'm running my application on two separate RH8 linux bokses using Jboss
    > 3.0.7 on the appserver and db2 8.1 fp3 on the db server.
    >
    > I am also running db2 8.1 fp2 on my appserver which seems to be working
    > perfectly fine towards the same apps.
    >
    > My problem is that randomly the connection seems to stop up for 10-20
    > seconds before it continues. I also get the following error in my
    server.log
    > file
    > (jboss)2003-09-12 15:04:47,498 ERROR [STDERR] -99999
    > . And it seems to occur approx. at the same time as the server hangs.
    There
    > are no error messages in the db2diag.log files.
    >
    > It is really strange that this only fails when accessing the remote
    server.
    > I am using the latest fp3 jcc driver to connect both locally and to the
    > remote db server.
    >
    > The databases are exactly the same since I am using a restored db on the
    > remote host. The instances on both servers have been set up with the same
    > parameters, as well as the databases.
    >
    > I do not reakon this to be a jboss problem, as it works fine with the
    local
    > databases.
    >
    > If this is a fp3 problem is the solution to reinstall db2 with fp2?
    >
    > Hope someone out there has an answer.
    > I would be truly greatful.
    >
    > regards
    > Thomas Sigdestad
    >
    >

    PM \(pm3iinc-nospam\) Guest

Similar Threads

  1. Moving from localhost (windows) to Remote(Linux)
    By kwartz2 in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: June 4th, 04:54 PM
  2. Connection Drops Randomly During Editing
    By Jim@Culpeper.com in forum Macromedia Contribute Connection Administrtion
    Replies: 1
    Last Post: October 6th, 09:43 AM
  3. Permanent connection between a LINUX server and a UNIX AIX server
    By Robert PADOVANO in forum Linux / Unix Administration
    Replies: 1
    Last Post: April 23rd, 01:34 PM
  4. Considerations on Connecting to MS SQL Server from PHP/Linux
    By Google Mike in forum PHP Development
    Replies: 0
    Last Post: December 7th, 02:20 PM
  5. Mac OS X trouble connecting to Linux VPN server
    By Bev A. Kupf in forum Mac Networking
    Replies: 1
    Last Post: August 7th, 01:05 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