ANALYZING DB2 DATA SHARING PERFORMANCE PROBLEMS

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. 1