< Day Day Up > |
IN THIS CHAPTER
DB2 automatically guarantees the integrity of data by enforcing several locking strategies. These strategies permit multiple users from multiple environments to access and modify data concurrently. DB2 combines the following strategies to implement an overall locking strategy:
What exactly is locking? How does DB2 utilize these strategies to lock pages and guarantee data integrity? Why does DB2 have to lock data before it can process it? What is the difference between a lock and a latch? How can DB2 provide data integrity while operating on separate partitions concurrently? Finally, how can DB2 avoid locks and still guarantee data integrity? These questions are answered in this chapter. In addition, this chapter provides practical information on lock compatibilities that can aid you in program development and scheduling. |
< Day Day Up > |