Looks to me that you are just getting a warning stating that this change
can not be done online.
Stop and start your database and then the bufferpool should be there.
SQL20189W The buffer pool operation (CREATE/ALTER) will not take
effect until the next database startup due to
insufficient memory.
Explanation:
The CREATE or ALTER BUFFERPOOL statement was issued and
completed successfully, however due to insufficient memory the
create/alter was done DEFERRED. The changes will take effect on
the next database startup.
User Response:
If you do not want to wait until the next startup to activate or
resize the buffer pool, you can free memory resources and try
again (with the same or different size). Memory resources that
can be reduced include other buffer pools, the database heap, the
catalog cache, the package cache, and the utility heap. These can
be reduced using the ALTER/DROP BUFFERPOOL or UPDATE DATABASE
CONFIGURATION command depending on the resource. In the future,
to reserve extra memory for the dynamic allocation of buffer pool
memory, you can increase the DATABASE_MEMORY database
configuration parameter.
If you do not try again:
1. If it is an ALTER BUFFERPOOL that failed, you will continue
to run with the current runtime size of the buffer pool. You
can use the database monitor to see the current runtime size
of the buffer pool.
2. If it is a CREATE BUFFERPOOL that failed, any table spaces
that are created in the buffer pool will temporarily (until
next startup) be put in a hidden buffer pool with the
matching pagesize. Since the hidden buffer pools are small,
this can result in lower than desired performance.
To try again:
1. For ALTER BUFFERPOOL, resubmit the command.
2. For CREATE BUFFERPOOL drop the buffer pool and then resubmit
the command.
sqlcode : 20189
sqlstate : 01657
-----Original Message-----
From: Gandra, Narayan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 4:09 PM
To: [EMAIL PROTECTED]
Subject: [DB2EUG] create bufferpool errors - help
Hi,
I am working DB2 UDB 8.1 with FP2 on Solaris 2.8. This unix box contain
around 6 GB memory and when I am trying to creating bufferpool using the
following sql:
$ db2 "create bufferpool testbp size 100000 pagesize 4k"
SQL20189W The buffer pool operation (CREATE/ALTER) will not take effect
until
the next database startup due to insufficient memory. SQLSTATE=01657
$ top
load averages: 0.07, 0.08, 0.09
93 processes: 91 sleeping, 2 on cpu
CPU states: 97.1% idle, 1.6% user, 1.3% kernel, 0.0% iowait, 0.0%
swap
Memory: 6144M real, 5336M free, 2050M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
28632 war81064 1 59 0 1488K 1272K cpu3 0:00 0.03% top
941 root 10 40 0 3632K 3344K sleep 0:03 0.01% nscd
23854 war81064 1 58 0 125M 94M sleep 0:02 0.01% db2sysc
14380 root 1 58 0 5136K 3696K sleep 0:02 0.01% db2fmcd
130 root 7 58 0 3136K 1912K sleep 1:07 0.00% devfsadm
1392 root 12 58 0 2712K 2456K sleep 0:06 0.00% mibiisa
23877 war81064 1 58 0 88M 62M sleep 0:02 0.00% db2sysc
433 root 15 58 0 23M 12M sleep 0:02 0.00% vxsvc
515 root 5 58 0 3520K 2440K sleep 0:02 0.00% automountd
20 root 1 59 -19 9040K 7720K sleep 0:02 0.00% vxconfigd
125 root 14 33 0 4920K 2744K sleep 0:01 0.00% syseventd
1175 root 38 147 -20 58M 5856K sleep 0:01 0.00% rgmd
1122 root 7 100 -20 0K 0K cpu2 0:00 0.00% rpc.pmfd
26608 war81064 1 0 0 117M 74M sleep 0:00 0.00% db2sysc
26609 war81064 1 0 0 85M 43M sleep 0:00 0.00% db2sysc
Actualy I want to create a bufferpool with 2 GB size and is it possible
to
create that much size bufferpool on above solaris box with 5336 M free.
Any help greatly appreciate.
Thanks!
GNR
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
