• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

WAS6.1 connection pool issue

 
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
My name is Inigo Montoya, you killed my father, prepare to read a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic