Db2 Coding - Defining Database Performance - Expert Videos
Duration
30 minutes
Overview
In these expert videos, a breakdown of what constitutes performance in relation to Db2 applications is discussed. The presenter begins with a high-level view of performance, and the factors to be considered when coding, and managing Db2 applications.
Audience
This is aimed at individuals whose job role is to analyze and improve the performance of their Db2 database environment.
Prerequisites
Solid knowledge of Db2 database structures, processing of mainframe workloads, and system resources.
Objectives
After completing this course, the student should be able to:
- Identify the four components influencing application performance
- Describe how Db2 application performance can be impacted
- Describe how decreasing CPU usage and I/O operations, and increasing concurrency, improves performance
Course Content
Providing a Definition
What is Performance?
Understanding Database Performance
Importance of Database Performance
Workload, Resources, Throughput, and Contention
The Four Components
Understanding Workloads
Workload Components
Hardware and Software Resources Required by Applications
Impact of Throughput
Resource Contention
Diving a Little Deeper
Factors Influencing Db2 Application Performance
Host Language and SQL Code
Database structures
Tablespaces and Tables
Db2 Subsystem Parameters
Operating System Settings
CPU and Elapsed Time
Db2 Buffer Pools
Increasing Overall Concurrency of Work