Recommendations for performance

For best performance, keep GBP-dependent page sets in separate buffer pools from non-GBP-dependent page sets.

For example, keep work file table spaces, which are always non-GBP-dependent, in different buffer pools than those used by GBP-dependent page sets. Assign work file table spaces to a buffer pool other than BP0. This separation helps Db2 more efficiently handle registering pages to, and unregistering pages from, the group buffer pool.

• Create a buffer pool specifically for LOBs to improve the efficiency of read LRSN value.
• Data rows that are too large for a single 4-KB page can use an 8-KB, 16-KB, or 32-KB page to improve the balance for different processing requirements. This allows you to store larger rows more efficiently and improve performance.