dcruncher4@aim. com wrote:
The issue here is that you're hitting bufferpool 4097. This is the
"hidden" 8k bufferpools that will be used if your system does not have
enough memory to support the regular bufferpools. These bufferpools
are VERY small (64 pages, I think), so it's very easy to fill all of
the pages.
Your BP1 bufferpool is just over 1Gb in size. I don't know what other
bufferpools you've got, but check on the size of these and make sure
that your system has enough memory to support them.
When you do:
db2stop force
db2start
db2 connect to test
You should *not* get any error messages on the CONNECT statement. If
you do, you're oversized.
I am new to DB2.
>
version info DB2 9.5 , Linux
>
some more info:-
create bufferpool bp1 size 140000 pagesize 8K ;
update db cfg for test using CHNGPGS_THRESH 5 ;
update db cfg for test using NUM_IOCLEANERS 3 ;
update db cfg for test using NUM_IOSERVERS 3 ;
>
I am tying to convert a perl program to multi threaded.
To test the difference I created a table and loaded 100000 rows.
It loads fine as a single thread program. Loads it in about 15 seconds.
>
When I run it as multi threaded with 3 threads and all 3 of them inserting, I
frequently
get this message:-
>
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUX] SQL1218N There are no
pages currently available in bufferpool "4097". SQLSTATE=57011
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUX] SQL1218N There are no
pages currently available in bufferpool "4097". SQLSTATE=57011
>
version info DB2 9.5 , Linux
>
some more info:-
create bufferpool bp1 size 140000 pagesize 8K ;
update db cfg for test using CHNGPGS_THRESH 5 ;
update db cfg for test using NUM_IOCLEANERS 3 ;
update db cfg for test using NUM_IOSERVERS 3 ;
>
I am tying to convert a perl program to multi threaded.
To test the difference I created a table and loaded 100000 rows.
It loads fine as a single thread program. Loads it in about 15 seconds.
>
When I run it as multi threaded with 3 threads and all 3 of them inserting, I
frequently
get this message:-
>
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUX] SQL1218N There are no
pages currently available in bufferpool "4097". SQLSTATE=57011
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUX] SQL1218N There are no
pages currently available in bufferpool "4097". SQLSTATE=57011
The issue here is that you're hitting bufferpool 4097. This is the
"hidden" 8k bufferpools that will be used if your system does not have
enough memory to support the regular bufferpools. These bufferpools
are VERY small (64 pages, I think), so it's very easy to fill all of
the pages.
Your BP1 bufferpool is just over 1Gb in size. I don't know what other
bufferpools you've got, but check on the size of these and make sure
that your system has enough memory to support them.
When you do:
db2stop force
db2start
db2 connect to test
You should *not* get any error messages on the CONNECT statement. If
you do, you're oversized.