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.

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

Read about the DB2 snapshot monitor.

Also have a look at CONNECTIONS event monitor.....