Tuning memory in DB2

Tuning memory in DB2
Release 9.3

• Set up buffer pools.
Setting up the buffer pools is critical to performance. By default, DB2 provides a single buffer pool named IBMDEFAULTBP. The DB2 9 default characteristic for IBMDEFAULTBP is to use automatic sizing.
You should create a separate buffer pool for each table space. The database snapshot should be reviewed to check the buffer pool physical read values. The buffer pool should be large enough that a snapshot of a map redraw results in a small number of physical reads.
• Properly set the package cache size parameter (PCKCACHESIZE).
Package cache size specifies the amount of memory allocated for caching dynamic and static SQL requests. This is allocated at database startup and freed at shutdown. If DB2 does not find a SQL statement in the package cache, the statement will need to be recompiled (dynamic SQL) or loaded from the package catalog (static SQL), which can consume considerable time.
The DB2 9 default parameter value for PCKCACHESIZE is AUTOMATIC. Depending upon system configuration, you may not have to maintain this item.
ESRI recommends you start with an initial size of 6,000 and monitor the package cache lookups and package cache insert values in a database snapshot.