DB2 for z/OS and OS/390 - System Overview & Performance Basics
 

In today's complex environments a shared understanding of resource usage and performance between systems and database
administration personnel is critical.

This 1 day course is intended for:

Systems Programmers, Systems Administrators and Technical Database Administrators. The course describes the layout and content of the various DB2 data and system structures, what facilities are supplied to manage the DB2 environment and how DB2 relates to the MVS environment..

Topics Covered:

• Introduction to the DB2 Environment
• DB2 Database Services
• DB2 System Services
• DB2 Internal Resource Lock Manager

Objectives:

Understand:

• The DB2 address space layouts
• The resources required to implement new database structures
• Application plans and packages
• Resources required to support the execution of those applications

Duration: 1 day

Delivery: Class Lecture

Audience: 

System Programmers, System Administrators and Technical Database Administrators

Prerequisites:

Basic working knowledge of DB2 UDB for z/OS and OS/390

NOTE:

This course does not cover issues related to Sysplex data sharing.

Outline

1. Introduction to the DB2 Environment

DB2 Overview / Address Spaces

2. DB2 Subsystem Structure

DB2 Address Spaces Structure
Improving Main Storage Utilization
DASD Storage for the DB2 Subsystem
Tailoring & Tuning approach
ZPARM Example

3 . DB2 Database Services

DBAS Overview
DB2 Directory
EDM Pool
DB2 Catalog
Database Buffer Pools
RID Pool Storage
Sort Pool Storage

4. DB2 System Services

SSAS Overview
Bootstrap Data Set (BSDS)
Logging & Recovery
SSAS Review

5. DB2 Internal Resource Lock Manager

IRLM Address Space Overview
Recommendations for System Options
Tuning your use of Locks
Monitoring DB2 Locking