SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

z/OS and DB2 Training


The instructor was very knowledgeable and went beyond the course expectations. He also explained database concepts and made sure the students understood the topics. I will definitely recommend this course to my co-workers.
Comment from Canada School of Public Service

1. Title

  • The Complete DB2 Administration Course for z/OS on Mainframe (DB2COM, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous experience with relational databases in a Linux environment

3. Target Audience

  • IT professionals who want to learn how to adminster a DB2 installation on z/OS

4. Dates and Pricing


May 30 to Jun 2, 2017$3,900.00/person
Sep 5 to Sep 8, 2017$3,900.00/person
Nov 7 to Nov 10, 2017$3,900.00/person

5. Outline

Module 1: DB2 Administration and Configuration

Topic 1: Creating and Configuring Instances for Non-Partitioned Environments

Topic 2: Creating and Configuring an Instance for Multi-Partitioned Environments

Topic 3: Creating and Configuring a Client Instance

Topic 4: Starting and Stopping Instances

Topic 5: Configuring SSL for Client-Server Instance Communication

Topic 6: Listing and Attaching To Instances

Topic 7: Dropping Instances

Module 2: Non-partitioned Database

Topic 1: Creating and Configuring DB2 Non-Partitioned Databases

Topic 2: Using Configuration Advisor

Topic 3: Creating a Database from an Existing Backup

Topic 4: Configuring Automatic Database Maintenance

Topic 5: Managing Federated Databases?Connecting To Oracle and MSSQL

Topic 6: Altering Databases

Topic 7: Dropping Databases

Module 3: DB2 Multi-partitioned Databases

Topic 1: Creating and Configuring a Multi-Partitioned Database

Topic 2: Adding Database Partitions

Topic 3: Creating Database Partition Groups

Topic 4: Altering Database Partition Groups

Topic 5: Managing Data Redistribution on Database Partition Groups

Topic 6: The Table Distribution Key and Its Role

Topic 7: Removing Partitions from a Database Partition Group

Topic 8: Removing Database Partitions

Topic 9: Converting a Non-Partitioned Database To a Multi-Partitioned Database

Topic 10: Configuring Fast Communication Manager

Module 4: Using DB2 Table Spaces

Topic 1: Creating and Configuring Table Spaces within Automatic Storage Databases

Topic 2: Creating and Configuring SMS Table Spaces

Topic 3: Creating and Configuring DMS Table Spaces

Topic 4: Using System Temporary Table Spaces

Topic 5: Using User Temporary Table Spaces

Topic 6: Altering Table Spaces and Dropping Table Spaces

Topic 7: Table Spaces in a Multi-Partitioned Environment

Module 5: DB2 Buffer Pools

Topic 1: Creating and Configuring Buffer Pools

Topic 2: Configuring the Block-Based Area

Topic 3: Managing Buffer Pools in a Multi-Partitioned Database

Topic 4: Altering Buffer Pools

Topic 5: Dropping Buffer Pools

Module 6: Database Objects

Topic 1: Creating and Using MDC Tables and Block-Based Indexes

Topic 2: Creating and Using Materialized Query Tables

Topic 3: Implementing Table Partitioning

Topic 4: Using Temporary Tables

Topic 5: Created Global Temporary Table

Module 7: DB2 Backup and Recovery

Topic 1: Configuring Database Logging

Topic 2: Performing an Offline Database Backup

Topic 3: Performing a Full Online Database Backup

Topic 4: Performing an Incremental Delta Database Backup

Topic 5: Performing an Incremental Cumulative Database Backup

Topic 6: Table Space Backups

Topic 7: Crash Recovery

Topic 8: Full Database Recovery

Topic 9: Database Rollforward Recovery

Topic 10: Incremental Restore

Topic 11: Recovering Table Spaces

Topic 12: Redirected Restore

Topic 13: Recovery History File

Topic 14: Configuring Tape-Based Backup

Topic 15: db2move and db2look Utilities

Module 8: DB2 High Availability

Topic 1: Setting Up HADR by Using the Command Line

Topic 2: Setting Up HADR by Using Control Center

Topic 3: Changing HADR Synchronization Modes

Topic 4: Performing Takeover and Takeover by Force

Topic 5: Using Automated Client Rerouting with HADR

Topic 6: Opening the Standby Database in Read-Only Mode

Topic 7: Using the DB2 Fault Monitor

Module 9: Problem Determination, Event Sources, and Files

Topic 1: Using db2mtrk

Topic 2: Using db2pd

Topic 3: Using db2dart

Topic 4: Using db2ckbkp

Topic 5: Using db2support

Module 10: DB2 Security

Topic 1: Managing Instance-Level Authorities

Topic 2: Managing Database-Level Authorities and Privileges

Topic 3: Managing Object Privileges

Topic 4: Using Roles

Topic 5: Using Table Encryption

Topic 6: Using Label-Based Access Control (LBAC) To Strengthen Data Privacy

Topic 7: Auditing DB2

Module 11: Connectivity and Networking

Topic 1: Configuring Network Communications

Topic 2: Cataloging and Un-Cataloging

Topic 3: Using DB2 Discovery

Topic 4: Communications with DRDA Servers (Z/OS and I/OS)

Topic 5: Monitoring and Configuring FCM for Optimal Performance

Module 12: Monitoring

Topic 1: Configuring and Using System Monitoring

Topic 2: Configuring and Using Snapshot Monitoring

Topic 3: Configuring and Using Event Monitoring

Topic 4: Using Memory Visualizer

Topic 5: Using Health Monitor

Module 13: DB2 Tuning and Optimization

Topic 1: Introduction and General Tuning Guidelines

Topic 2: Operating System Tuning

Topic 3: Resolving CPU Bottlenecks

Topic 4: Tuning Memory Utilization

Topic 5: Collecting Object Statistics with the RUNSTAT Utility

Topic 6: Default Automatic Statistics Collection

Topic 7: Tuning with Indexes

Topic 8: Tuning Sorting

Topic 9: Hit Ratios and Their Role in Performance Improvement

Topic 10: I/O Tuning

Topic 11: Using Logging and No-logging Modes

Topic 12: Using Parallelism

Topic 13: Loading a Table

Topic 14: Using EXPLAIN PLAN

Topic 15: Creating a Benchmark Testing Scenario

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette