Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WAS6.1 connection pool issue

 
Richard Vagner
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Our web app uses Websphere App server 6.1 and db2 database. We got into a situation where a db2 load job essentially prevented the web application from accessing the database and web application just hung.

The problem is after the db2 load job completed for some time, the web application still hung. It looks like a race condition in connection pooling. I was wondering why the connection pooling is not getting back to normal automatically after the load job is long gone?

Please throw some light on this.

Thanks,
Rich
 
Joseph Hayes
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using container managed persistence? If not, it will be application specific, I'm afraid.

If it's container managed, are you eventually getting connection timeout exceptions?

If not, the only possibility that I can think of at the moment is that you're somehow keeping connections active but not doing anything with them. The configuration solution for this (as opposed to the programming solution, which should likely be investigated depending on the impact of the outage) would be to use the "aged timeout" setting in the datasource's connection pool. In admin console, navigate as follows: JDBC providers > [your db2 provider] > Data sources > [your datasource]> Connection pools

Reference here for more detail on this: http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.base.doc/info/aes/ae/umj_sesspoolset.htm
 
Richard Vagner
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Joseph,

Thanks so much. Actually I was thinking about the same thing: Aged Timeout. However, my collegue said once a connection is being used it would never be aged timeout. IBM doc seems to suggests that the physical connection wil not be discarded if the connection is involved in a transaction when the aged timeout is reached.

Can you give me a snario where we might be keeping connections active but not doing anything with them as you suggested?

I think that maybe our problem.

Thanks,
Rich
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic