O'Reilly logo

DB2® Universal Database for OS/390® Version 7.1 Certification Guide by Susan Lawson, Richard Yevich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Maintaining Data Integrity

Data that is defined as “sharable” can be accessed by any DB2 in the group. Several subsystems can read and write simultaneously against the same data. This is controlled via “inter-DB2 Read/Write interest.” Changed data, or data with “inter-DB2 R/W interest” is always cached in the group buffer pool; this data becomes “group bufferpool dependent.” The coupling facility will control the invalidations of changed pages in all members' local buffer pools.

Consistency of data among the DB2 members in the data sharing group is protected in two ways:

  • Concurrency controls

  • Coherency controls

In order to provide concurrency controls among the DB2 members in the data sharing group, a new locking structure is used. Since tuning ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required