Db2 Coding - Coding for Concurrent Access - Expert Videos
Duration
50 minutes
Overview
These expert videos look at concurrency, how it works, and the performance benefits it can provide. You will see how Db2 table spaces, tables, pages, and rows can be locked and when each of these types of locks should be considered for use. Details on isolation levels, how they are specified, and the impact they have on your SQL program is also presented. A section on common concurrency problems including lock suspensions, timeouts, and deadlocks is covered, and how they can be avoided. You will also see how parallelism is enabled and how it is used to improve processing efficiency.
Audience
This is aimed at individuals whose job role is to analyze and improve the performance of their Db2 database programs.
Prerequisites
Successful completion of the Interskill, Db2 Coding - General SQL and Indexing Guidelines - Expert Videos, or equivalent knowledge.
Objectives
After completing this course, the student should be able to:
- List Db2 Locking Types and Describe When They Should be Used
- Describe How Isolation Levels are Used
- Identify the Characteristics of Lock Suspensions, Timeouts, and Deadlocks
- Describe the Benefits of Parallelism
Course Content
Introduction to Concurrency
Concurrency Concepts
Benefits of Concurrency Operations
Locking
Locking Basics
Lock Granularities
Locks Required for Reading and Updating Data
Table Space Locks
Page Locks
Lock Compatibility
Row Locks
Acquiring Table Space Locks
Locking Duration and Binding
Lock Duration
Factors Impacting Lock Duration
Isolation Levels
Cursor Stability Isolation
Repeatable Read Isolation
Read Stability Isolation
Uncommitted Read Isolation
Locking Issues and Strategies
Lock Suspension
Timeouts
Deadlocks
Coding for Concurrency
Implementing a COMMIT Strategy
Using the LOCK TABLE Statement
Query Parallelism
Parallelism Concepts
Enabling Parallelism
Queries That Benefit From Parallelism