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

z/OS and DB2 Training


The instructor appeared to be very knowledgeable with regard to all aspects of the course. He was quick to point out features which were new or had changed since previous versions, and called specific attention to information he thought was particularly relevant to us.
Comment from DND

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