About this Course

This 4-day course is a must for all personnel who need a comprehensive understanding of the DB2 System environment. During this hands-on course the attendee will install their own DB2 subsystem, migrate their subsystem to a new release and analyze each address space for workload and performance considerations. Additionally detailed attention is given to the layout and content of the various DB2 data & system structures, what facilities are supplied to manage the DB2 environment and how DB2 relates to the z/OS environment. This course also reviews the DB2 Install parameters and presents an introductory approach to tuning your system.

Audience Profile

DB2 Systems Programmers, DB2 Systems Administrators and Technical Database Administrators.

At Course Completion

Attendees will gain a working knowledge of:

• DB2’s Multi-Address space Subsystem
• DB2’s System Resources
• DB2 Installation Tailoring
• What factors affect DB2 Subsystem performance

Prerequisites

An overview understanding of DB2, basic understanding of z/OS.

Course Outline

1. Introduction to the DB2 Environment

• DB2 Overview
• DB2 and z/OS
• DB2 Deliverables
• SYSADM/DBADM Roles
• Performance Overview

2. DB2 Installation

• DB2 Installation and Migration Overview
• DB2 Installation Planning
• DB2 Install Panels
• Tailoring the Install Jobs
• Verifications

3. DB2 Migration

• DB2 Migration Planning
• Multi-Phase Migration
• Pre-Migration preparation
• Migration Panels
• Tailoring the Migration Jobs
• Enable New Function Mode
• Migration Check List

4. DB2 Database Services Address Space

• Database Services Address Space Overview
• DB2 Database Objects
• Virtual Storage Requirements
  • EDM Pool
  • Buffer Pools
  • Sort Storage
  • Rid Pool Storage
• Administrative Responsibilities

5. DB2 System Services Address Space

• Systems Services Address Space
• ssnmMSTR Critical Resources
  • BSDS
  • Active Logs
  • Archive Logs
  •  
• Recovery Considerations
• Managing the BSDS and Logs
• Performance

6. DB2 Internal Resource Lock Manager and Concurrency Control

• DB2 Resource Serialization
• IRLM Address Space (xxxxIRLM)
• Tuning your use of Locks
• Critical Lock Management zparms

7. DB2 Distributed Data Services

• Connectivity Options
• DDF Address Space (xxxxDIST)
• Enabling TCP/IP Communication
• Installing Options
• Data Sharing Group
• Distributed Performance

8. Introduction to Stored Procedures

• Stored Procedures benefit the Client/Server Environment
• Installation Considerations for Stored Procedures
• WLM and the Stored Procedures Environment
• Key Performance Issues

9. DB2 Data Sharing Overview

• What is a Sysplex?
• Why Sysplex?
• Sysplex Environment
• Coupling Facility Technology
• Installation & Migration Considerations
• Key Performance Options

10. DB2 Security

• Security Overview
• Access Control Options
• Recommendations
• Security Control Install Parameters Review