Broadcom - Interskill Learning Mainframe Training

[email protected]

The Online Mainframe Training Specialists
Search   Course Catalog  
Return to Catalog Home     Return to Curriculum Listing

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


Search our catalog