Performance monitoring and tuning for data sharing environments

Actions such as tuning your use of locks and managing your group buffer pools can improve the performance of your data sharing group.

One of the main objectives of the data sharing function of Db2 for z/OS® is to increase processing capacity while using the lower cost IBM® zSystems Parallel Sysplex® technology. Workload capacity is increased by allowing many Db2 subsystems to access shared Db2 data with full integrity. Db2 data sharing is designed to address this objective while providing balanced performance for a broad range of SQL applications.

Db2 gives you the power of data sharing while avoiding overhead, whenever possible, for such things as global locking and data caching. However, you can take additional action to reduce the performance cost of data sharing.