Analyzing DB2 Data Sharing Performance Problems

                             Donald R. Deese

DB2 data sharing offers many advantages in the right environment, and performs very well
when DB2 is properly tuned. DB2 data sharing can significantly increase capacity, it offers
increased availability, and it provides a flexible operating environment. In certain
environments, DB2 data sharing can dramatically improve performance of DB2 subsystems
(e.g., when most data are shared and most of the shared data can fit into group buffer pools,
data sharing members do not have to continually reference DASD). On the other hand,
remarkably unsatisfying DB2 performance can be the result if DB2 data sharing is poorly
tuned. This paper describes common problems with DB2 data sharing, and offers alternative
solutions to the problems.

Download paper (pdf format).

Return to main page

Last updated by Don Deese on 12/21/01.