DB2 Locking and Concurrency: The Big Picture
by Dwaine R. Snow, Sylvia F. Qi, Clara Liu, Raul F. Chong
Understanding DB2®: Learning Visually with Examples
- Copyright
- IBM Press
- Foreword
- Preface
- Acknowledgments
- About the Authors
- Introduction to DB2 UDB
- A Brief History of DB2
- DB2 software and the IBM E-Business On-Demand Model
- DB2 UDB Editions
- DB2 UDB Clients
- “Try and Buy” Versions
- Host Connectivity
- Federated Support
- Replication Support
- IBM DB2 Information Integrator
- Special Package Offerings for Developers
- DB2 Syntax Diagram Conventions
- Case Study
- Summary
- Review Questions
- DB2 at a Glance: The Big Picture
- Installing DB2
- DB2 Installation: The Big Picture
- Required User IDs and Groups
- Installing DB2 Using the DB2 Setup Wizard
- Silent Install Using a Response File
- Installing DB2 Manually (Linux/UNIX Only)
- Installing a DB2 License
- Installing DB2 in a DPF Environment
- Installing DB2 FixPaks
- Case Study
- Summary
- Review Questions
- Using the DB2 Tools
- Understanding the DB2 Environment, DB2 Instances, and Databases
- Configuring Client and Server Connectivity
- Working with Database Objects
- The DB2 Storage Model
- Leveraging the Power of SQL
- Implementing Security
- Understanding Concurrency and Locking
- Maintaining Data
- Developing Database Backup and Recovery Solutions
- Database Recovery Concepts
- DB2 Transaction Logs
- Recovery Terminology
- Performing Database and Table Space Backups
- Database and Table Space Recovery Using the RESTORE DATABASE Command
- Database and Table Space Roll Forward
- Recovering a Dropped Table
- The Recovery History File
- Database Recovery Using the RECOVER DATABASE Command
- High Availability Through Online Split Mirroring and Suspended I/O Support
- High Availability Disaster Recovery
- Using DB2 Tools to Inspect the Health of Your Database
- Case Study
- Summary
- Review Questions
- The DB2 Process Model
- The DB2 Memory Model
- DB2 Memory Allocation: The Big Picture
- Instance-Level Shared Memory
- Database-Level Shared Memory
- Application-Level Shared Memory
- Agent-Level Private Memory
- The Memory Model
- 32-Bit Memory Model Considerations
- 64-Bit Memory Model Considerations
- AWE Support with Windows
- Case Study
- Summary
- Review Questions
- Database Performance Considerations
- Performance Fundamentals
- System/Server Configuration
- The DB2 Configuration Advisor
- Configuring the DB2 Instance
- Configuring Your Databases
- Lack of Proper Maintenance
- The Snapshot Monitor
- Event Monitors
- The DB2 Optimizer
- The Explain Tool and Explain Tables
- Using Visual Explain to Examine Access Plans
- Case Study
- Summary
- Review Questions
- Diagnosing Problems
- Solutions to the Review Questions
- Use of Uppercase Versus Lowercase in DB2
- IBM Servers
- Using the DB2 System Catalog Tables
- Setting Up Database Connectivity for DB2 UDB for z/OS and DB2 UDB for iSeries
- Diagnosing DB2 Connectivity Problems
- Resources
- Glossary
- About the CD-ROM
- CD-ROM Warranty
- Index
11.1. DB2 Locking and Concurrency: The Big Picture
Figure 11.1 provides an overview of the DB2 locking mechanism using isolation levels. Isolation levels can be configured by various methods. Depending on the isolation level specified, DB2 performs database locking differently. The following sections discuss these in more detail.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.