Use separate buffer pools that are based on their type of usage by the applications. Each one of these buffer pools has its own unique settings and the type of processing may even differ between batch and on line.
Detailed Example of Buffer Pool Object Breakouts
BP0 Catalog and directory - DB2 only use BP1 Work files (Sort) BP2 Code and reference tables - heavily accessed BP3 Small tables, heavily updated - trans tables, work tables BP4 Basic tables BP5 Basic indexes BP6 Special for large clustered, range scanned table BP7 Special for Master Table full index (Random searched table) BP8 Special for an entire database for a special application BP9 Derived tables and "saved" tables for ad-hoc BP10 Staging tables (edit tables for short lived data) BP11 Staging indexes (edit tables for short lived data) BP12 Vendor tool/utility object
|
Copyright © 2013 CA Technologies.
All rights reserved.
|
|