Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: zombie db connection

    How do we find zombie/orphon/defunct database connection .
    Seems like applicaton is down but even we see some connection coming from application.
    so we need to figure out even when application is up or down that what are this zombie connection which exists on database doing nothing ( obviously ) but not on client or application.

    TIA.

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    In our environment, the weblogic/websphere keeps the connection pool.
    even if the application is down, also in cluster web environment, I have
    seen this problem.
    The best thing is to remove connection fromt the source.The dba should
    monitor that this is actually happening.

    Otherwise you can use

    db2 force application(<appl_id>)

    or you can force all applications

    db2 force applications all

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    zombie connection

    Thanks for prompt reply!

    would you explain ,remove from the source ( database or application )

    But, my question is how to find such zombies when application is up with some good connection and some such zombies ? In that scenario we want to remove such connection but root question is how to find from database side.
    Waht could be the cause of such zombies ? anything with application weblogic/Web/app server or database ?

    We know in other RDBMS like Oracle / Sybase we can do that.

    TIA.

  4. #4
    Join Date
    Mar 2004
    Posts
    448
    1. Remove from source ==== at the apps/web server.
    2. Best way to find is the snapshot at the application at database.. It usually shows the connect time/status change time.
    3. At the weblogic/websphere , they have scripts to start and stop the server.

    Make sure that when ever the apps server stopped. all the connection
    also gone at the database.

    4. Tune the connection pool parameter. it has connection alive time/initial no of connections etc.Refer to the web/apps documentation.


    regards

    Mujeeb

Posting Permissions

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