Exception while running number of queries concurrently on DB2?

The pagesize of a bufferpool has to match the pagesize of the tablespaces it is associated with. Do all of your tablespaces use 32K pages? You should check whether there is a different bufferpool that is running out of pages.10,000 pages should be more than enough to avoid the error you are seeing.

The most likely cause is your transactions are not issueing "commits" so there is buildup of uncommited data in the buffer pools. Also 32K seems very small for current hardware ( Since DB2 can handle CLOBs and BLOBs of several megabytes) 32MB or more would be more appropriate for a bufferpool size.

We are committing after each record is inserted/updated. So, redo log is not a problem. (buffer pool will never be over-flooded).32K is the page size of the buffer pool & buffer pool contains 10000 pages.So, are these configurations appropriate for the buffer pool?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.