Tuning DB2 for Solaris for OLTP Workloads
OLTP workloads vary considerably, making it difficult to establish a set of tuning rules with general applicability. But there are guidelines that should apply to most situations.
Successful tuning requires careful planning in the initial stages. Laying out the data is very important. Never forget, too, that applications have more potential to cause poor performance than does DB2 tuning. Once the applications have been tuned and the explain plans for your SQL seem reasonable, DB2 tuning can give you a small but welcome performance boost.
Choosing a Page Size
As of DB2 UDB V6.1 a choice of page sizes is available (4, 8, 16, or 32 Kbytes). For OLTP applications, a small page size is usually a good choice. ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
