Summary

Team-Fly    

 
DB2 Universal Database for OS/390 v7.1 Application Certification Guide
By Susan Lawson
Table of Contents
Chapter 16.  Locking and Concurrency

Summary

In this chapter, we discussed how concurrency(serialization) is controlled. To protect the data as it is being modified, rules are established and the changes are grouped into units of work. The updated data is made permanent by the COMMIT statement or removed by the ROLLBACK statement. The rules of concurrency are determined by the isolation level, the lock size , and the rules of lock duration.

DB2 implements the isolation level semantics of data access by implicitly acquiring locks on behalf of applications. Applications can decide to lock a resource for exclusive or share modes. The resources that can be locked are the row, page, table, tablespace, and partition.

If a requested lock is more restrictive , and another application already has the resource locked, a wait on the release of the lock will occur. The amount of time an application will wait is determined by systemwide parameters for both resource timeout and deadlocks.

If multiple applications require access to data that is held by other applications, a deadlock scenario can occur. DB2 will detect the occurrence of any deadlocks and force one of the transactions to roll back. Every lock requested requires memory in the IRLM, and the amount of lock storage is configurable using IRLM parameters.


Team-Fly    
Top


DB2 Universal Database for OS. 390 v7. 1 Application Certification Guide
DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)
ISBN: 0131007718
EAN: 2147483647
Year: 2002
Pages: 163
Authors: Susan Lawson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net