Improved lock avoidance checking for data sharing environments

Db2 12 introduces improved lock avoidance checking, which results in better lock avoidance in data sharing environments.

Db2 12 accomplishes this through an increase in the granularity of lock avoidance checking, improving lock avoidance and reducing the traffic to the CF. The result is improved system performance.

For more information about these enhancements, see the following sections in Db2 12 for z/OS® Performance Topics (IBM Redbooks):

• Global commit LRSN enhancement
• Global read LSN enhancement