468,135 Members | 1,449 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,135 developers. It's quick & easy.

Swap space usage

Hello,

I have ntoiced something peculiar happening on our db2 instance.

It serves as the backend rdbms for a java application that is hosted on
websphere app server. The app server has a connection pool that can
grow upto 250 connection.

The database has also been configuired to handle this many connections.
The db2 server has 2GB of memory.

Over the course of te day, we see an increase in the swap space
consumption by almost 70%. The usual side effect this has is that we
have to restart the app server or else, the db2 server crashes.

Is there a known problem in this mode of operation? Could anyone offer
me some information/directions for investigations?

Many thanks.

Nov 12 '05 #1
2 4519
Need more information. What platform you running on? What service level?
What release/fixpack level of DB2 you running? Have you opened a PMR
with IBM support to check on any possible defects?

Larry Edelstein

cn******@yahoo.com wrote:
Hello,

I have ntoiced something peculiar happening on our db2 instance.

It serves as the backend rdbms for a java application that is hosted on
websphere app server. The app server has a connection pool that can
grow upto 250 connection.

The database has also been configuired to handle this many connections.
The db2 server has 2GB of memory.

Over the course of te day, we see an increase in the swap space
consumption by almost 70%. The usual side effect this has is that we
have to restart the app server or else, the db2 server crashes.

Is there a known problem in this mode of operation? Could anyone offer
me some information/directions for investigations?

Many thanks.


Nov 12 '05 #2
<cn******@yahoo.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com...
Hello,

I have ntoiced something peculiar happening on our db2 instance.

It serves as the backend rdbms for a java application that is hosted on
websphere app server. The app server has a connection pool that can
grow upto 250 connection.

The database has also been configuired to handle this many connections.
The db2 server has 2GB of memory.

Over the course of te day, we see an increase in the swap space
consumption by almost 70%. The usual side effect this has is that we
have to restart the app server or else, the db2 server crashes.

Is there a known problem in this mode of operation? Could anyone offer
me some information/directions for investigations?

Many thanks.

DB2 generally want to have real memory available for its use.

You need to start all your applications with DB2 shut down and determine how
much real memory is available, and then configure DB2 (especially the buffer
pools) to make sure you don't use more than the real memory available.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Benoit St-Jean | last post: by
2 posts views Thread by news.onet.pl | last post: by
14 posts views Thread by Otto Meijer | last post: by
3 posts views Thread by Kevin Bartz | last post: by
reply views Thread by Kevin Bartz | last post: by
11 posts views Thread by Dennis Jones | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.