Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: Track DB2 LUW connections

    I want to know how I can track connection information/state. Here's the problem we're having. We have an application that has connections to the db2 luw database and for some reason it gets to where it can't write to the db. At this point it starts putting the data in a buffer. When we see the buffer start to fill we do a force on any connections that the application has to the db. The application automatically reconnects and we start seeing the percent in the buffer start to go down and data being written to the db. There are now errors in our application or db logs. Thanks in advance for any help.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What do you mean by "for some reason it gets to where it can't write to the db"? Are you getting an error? what is the specific error?

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Read about the DB2 snapshot monitor.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    Also have a look at CONNECTIONS event monitor.....
    IBM Certified Database Associate, DB2 9 for LUW

Posting Permissions

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