var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Bufferpool usage
I would like to get the details of BUFFERPOOL USAGE for different instances. I am using DB2 UDB 7.2, running on AIX 4.3
I would greatly appreciate, if any one help me. Thanks in advance.
Hi. Bufferpool usage isn't really calculated at the instance level. You'll need to find the bufferpool defined for each database, and then sum up all the bufferpool sizes for all databases.
To get details on the bufferpool definitions:
select * from syscat.bufferpools
If you see a bufferpool defined to have -1 pages, it uses the BUFFPAGE value from the database cfg (db2 get db cfg for ...)