The "successful" means that your catalog table for bufferpools has been
updated successfully.
There was not enough memory (within the 1.75GB allowed for the 32 bit
environment) to allocate the pool "immediately".

The message says that memory will be allocated for all bufferpools when you
next activate the db.

Bear in mind, as said in another response to your post, that memory will be
allocated if it fits within the 1.75 GB constraint. This constraint varies
for different OS and their versions, from 800MB to 3.25 GB.
If not, you will get messages at the restart.
If you do not get any messages, it means that your db will consume whatever
the sum of poolS, locklist, package cache, catalog cache and dbheap will add
up to what is defined in your db cfg an/or db2mtrk.

Hope this helps, Pierre.
PS: The Quick Beginnings Ref. Manual will describe what you can allocate for
a 32 bit environment for specific OS version and DB2 version. Look in DB2
information Center
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "RLam" <db2udbdba-ezmlmshield-x40593343.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, February 26, 2007 1:07 PM
Subject: DB2 BUFFERPOOL


> Hello, I need your help.
>
> I increased a 4K buffer pool from 48,000 pages to 96,000 pages in our
> production instance and db2diag showed the following error:
>
> MESSAGE : ADM6050W The ALTER BUFFERPOOL statement for buffer pool
> "DATABP"
> (ID "6") was successful but could not be performed immediately
> because of insufficient memory. The change will take effect on
> the
> next database startup. Refer to the documentation for SQLCODE
> 20189.
>
> Actually our system still show over 8,000 MB memory FREE. Later I found
> out this was due to a known bug with AIX - DB2UDB 8.1 fixpak7 where the
> instance needs to be restarted for the new BP to take effect.
>
> My problem is that all 8 GB free memory has completely vanished after the
> restart.
>
> Is it safe for me to scale back my change or should I pick up the phone
> and call IBM support before someone breathes behind my back?
>
> Thank you very much for your help.
>
> db2mtrk -i -d shows
>
> Tracking Memory on: 2007/02/26 at 10:17:31
>
> Memory for instance
>
> monh other
> 144.0K 2.1M
>
> Memory for database:
>
> utilh pckcacheh catcacheh bph bph bph bph
> 32.0K 45.4M 2.6M 15.8M 387.3M 4.0M 15.8M
>
> bph bph bph bph bph bph bph
> 15.8M 15.8M 193.6M 624.0K 368.0K 240.0K 176.0K
>
> lockh dbh other
> 10.5M 5.6M 0
>
>
> Cheers
> Ray
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>



DB2 & UDB email list listserv db2-l LazyDBA home page