Not quite, a "how to" question, but I'm interested in knowing or having someone describe or show me an example of when a company or DBA would setup and use the Multi-Part Buffer Pool. I understand the purpose, but looking for something a little more concrete. Thanks in advance.
By multi-part buffer pool, are you talking about the DEFAULT, KEEP and RECYCLE pool?
I would certainly use the KEEP pool for any small table that was rarely altered and often queried. For example a table that just had descriptions for codes, where existing codes are rarely changed would be a good candidate.
Recycle is for all that data that is probably never going to be looked at again. Example of tables like that is perhaps ATM transaction logs where the data is very rarely looked at.