Folks,
I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?
I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this system.
# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
SQL20189W The buffer pool operation (CREATE/ALTER) will not take effect until
the next database startup due to insufficient memory. SQLSTATE=01657
when I re-start database I get following error:
# db2start
06/28/2005 16:50:18 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[[dbap3@lidp4]]/g6/dbap3>
# db2 connect to mydb
Database Connection Information
Database server = DB2/6000 8.2.1
SQL authorization ID = DBAP3
Local database alias = MYDB
SQL1478W The defined buffer pools could not be started. Instead, one small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626
I tried to to create 2GB bufferpool and that failed too.
# db2 create bufferpool cfgbuffpool immediate size 1048576 pagesize 4096
--
Hemant Shah /"\ ASCII ribbon campaign
E-mail:
No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.