• 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

Application Control heap size of DB2 with JDBC

 
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

There is a problem I am facing with DB2 database. We are unable to figure out whether the problem is with database or application level.

When this exception occured we saw that the exception was related to heap size of the database.

We checked the heap size it was 512, we increased it to 3092 but still problem persisted so we finally increased it to 8093.

Where as a similar application is runing with 512 heap size at the database with no problems.

We found that root where the exception encountered in the java program is where we say ResultSet.next and not with ResultSet.executeQuery.

We are confused here as we thought the problem might be with the database but when the problem occurs we restart the tomcat and for some days problem does not comes.

How come a database problem be solved because of the tomcat restart.

APP_CTL_HEAP_SZ is the database parameter which has to be set using database specific query.

for your info the data that is being fetched fromthe database when we encounter the exception is of type BLOB (blob like) as the data contains PHOTO and signature.

We only need your suggestions that will help us to find out the root cause.

Thanks

Rakesh K
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Rakesh,
Is it possible you have a resource leak in your application? This would explain why Tomcat restarting would help - it would purge those held connections/memory.
 
rakesh kadulkar
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Jeanne you mean to say that there are some connection which are unnecessarily open.

As far as I am aware of the project we are using a framework which automatically establishes a connection to the database before a business method call and releases it immediately after the method completes.

Well I am getting a clue that , my business method is very huge and at some parts only I need database hit and I am may be unnecessarily holding the conenction.

Let see what I can do with that.

Anyways thanks.

Rakesh K
 
That's my roommate. He's kinda weird, but he always pays his half of the rent. And he gave me this 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