Programmers Only: The Mystery of the DB2 SIX Lock

(Bonnie Baker) The SIX lock is one of DB2’s many mysteries. What is it, and how do we acquire it? Another mystery is the index_only flag on the plan_table: How can it be a Y for an UPDATE or a DELETE? Excuse me, but exactly how can an UPDATE or DELETE be “index-only?” A third mystery is the fact tha

Read More - Register for Free Membership