database buffer pool - BUFPOOLSIZE 2

[AIXtexas]

I received this error in the TSM activity log:

8/25/06 12:20:19 ANR0380W The database buffer pool recovered from an overcommit of 644 pages. Consider increasing your buffer pool size by 2576 kilobytes under current server load.

How do I go about checking it's current size and adjusting this?

Thanks,

Shane

 

[ProbablyDown]

You have to stop the server, edit the dsmserv.opt file, change the BUFPOOLSIZE option to the value in the error message, save and start the server:

http://publib.boulder.ibm.com/infoc...?topic=/com.ibm.itsmm.doc/update/ANR0380W.htm

 

[mbourne2006]

Morning

Do you really need to restart TSM?

What about "setopt bufpoolsize"?

Anyway, you can check current values with "q db f=d" or "q opt"

Important thing to note - if you increase the size of your buffer pool, watch out for paging - this will hammer performance something chronic. You may need to add RAM in order to support the increase in buffer pool size

Kind Regards,
Matthew Bourne
"Find a job you love and never do a day's work in your life.

 

[AIXtexas]

I heard there's a way to make the BUFPOOLSIZE dynamic. Is that true and is it a good idea?

Shane

 

[ProbablyDown]

Matthew is right actually, you can setopt that one..

To set it to self adjust - SELFTUNEBUFPOOLSIZE YES

from admin guide:

"Before expiration processing, the server resets the database buffer pool and examines the database buffer pool cache hit ratio. The server accounts for the amount of available storage and adjusts the buffer pool size as needed.

 

[AIXtexas]

Thanks everyone... I've got some good info to go on.

Shane