Toad World Blog

Db2 12 for z/OS: Enhanced Lock Avoidance in Data Sharing Environments

Oct 27, 2017 2:49:00 PM by Robert Catterall

In the last entry posted to this blog , I described the mechanisms (including PUNC bits and commit log sequence numbers, aka CLSNs) used by Db2 for z/OS for lock avoidance purposes (lock avoidance here refers to a capability whereby Db2 can, in many cases, verify the committed state of a data value without having to get an S-lock - i.e., a read lock - on the page or row in which the value is located). As lock and unlock requests consume CPU cycles, lock avoidance is a CPU efficiency booster for Db2 ...read more

 

Tags: Toad for IBM DB2 IBM DB2 DB2 z/OS

Robert Catterall

Written by Robert Catterall