Hi ,
we have db2 version 7.1 installed.in that version in db cfg we don't
have a parameter for database memory.also some of the command to get these
memories as per the version 8 also don't run.Please let me know if there is
any other way to find the instance memory,database memory,agent private
memory etc.
----- Forwarded by satish.sahoo/Polaris on 08/29/2006 02:54 PM -----
|---------+--------------------------------------------------------->
| | "jacob avidar " |
| | <db2udbdba-ezmlmshield-x41737838.[Email Address Removed] | azyDBA.com> |
| | |
| | 08/29/2006 02:14 PM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: (bcc: satish.sahoo/Polaris) |
| Subject: Re: Bufferpool page size |
>-----------------------------------------------------------------------------------------------|




Yes, you do.

You need first to increase the the DATABASE_MEMORY size to be at least
as big as the new bufferpool size you need.
Use the following command to check your current DATABASE_MEMORY size.
> db2 get db cfg for XXX show detail | grep memory (where XXX = your
db_name).
Use the following command to increase this size:
> db2 update db cfg for XXX using DATABASE_MEMORY new_size (where XXX =
your db_name, new_size = your db_new_size in pages of 4Kb).
In addition when altering bufferpool you do not need to explicitly write
"immediate" because it is done anyway for bufferpool.

Good luck,
Jacob.



On Sat, 2006-08-19 at 12:56 +0530, Rahul Yadav wrote:

> HI ,
> i am facing a buffer pool hit ratio of 48%,so i decided to increase
the
> page size
>
> " alter bufferpool IBMDEFAULT immediate size 24000"
>
> but it still showing me the same page size,am i required to do anything
else
> to implement the changes also am i right to increase the page size
there???
>
>
> Cheers,
> Rahul
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


---------------------------------------------------------------------
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


This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.

Visit us at http://www.polaris.co.in

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