Is there a way to segregate data buffers by DBID?

Document ID : KB000091686
Last Modified Date : 16/04/2018
Show Technical Document Details
Question:
I want to increase the overall MUF performance by adequate buffer allocations per DBID.
To protect business critical DBIDs from other buffer users.
Answer:

You can define alternate buffer pools to be assigned to specific DBIDs or areas. 
Alternate buffer pools are defined with the MUF startup option BUFFER_POOL_DEF.
See member DBDATIN2 which has some sample statements commented out: 
*BUFFER_POOL_DEF IXX01,4,15 POOL-NAME,BUFFER-SIZE,BUFFER-COUNT 
*BUFFER_POOL_DEF DXX01,4,15 POOL-NAME,BUFFER-SIZE,BUFFER-COUNT 
*BUFFER_POOL_DEF DATA1,4,15 POOL-NAME,BUFFER-SIZE,BUFFER-COUNT 

You then assign an area or DBID to the pool with the BUFFER_POOL_CONTENT startup option, for example: 
BUFFER_POOL_CONTENT DATA1,22 

You can also use the console commands BUFFER_POOL_CONTENT and BUFFER_POOL_COUNT to make changes to the buffer configuration. 
 

Additional Information:
See DocOps  section Alternate Buffer Pools 
Also see section BUFFER_POOL_DEF