Re: heavy inserts and bufferpool

<dcruncher4@[EMAIL PROTECTED]
> wrote in message news:fukoc902976@[EMAIL PROTECTED]
> I recreated the database with all default settings and changed only
> the  DB2_USE_ALTERNATE_PAGE_CLEANING=ON .
>
> I inserted 2 million rows in 2 threads parallely. Only 4 times it
> spewed out the error and only those 4 rows failed to insert.
>
> Thanks Mark and Serge.

Ian mentioned in this thread that the bufferpool you created is too large 
for the available real memory on your database server, and that is the 
source of your problem. The bufferpool BP1 did not get allocated because
of 
memory limitations and the DB2 hidden (very small) 8K bufferpool was used 
instead. This is the real source of your problem (although the other 
recommendations will help speed things up).

If you do the following, it will probably fix your problem permanently:

db2 alter bufferpool bp1 size 30000;

Then (just to be safe):

db2stop
db2start