Claims and Drains
Claims and drain locks are used to control currency between SQL processes and utilities, with partition independence being a major focus. Utilities and SQL can concurrently access and update different partitions, including different logical partitions of the non-partitioned indexes.
A logical partition refers to the set of index entries, which point to rows in a particular data partition. Logical partitions exist only in non-partitioned indexes of partitioned tables. An index entry belongs to one and only one logical partition.
Claims
When an application first accesses an object, within a unit of work, it makes a claim on the object. It releases the claim at the next commit point. Unlike a transaction lock, the claim cannot ...
Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
