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