Db2 for z/OS: Systems Administration

Learn via : Virtual Classroom / Online
Duration : 3 Days
  1. Home
  2. Db2 for z/OS: Systems Administration

Description

    This course is the definitive Db2 for z/OS systems administration course.

    It comprises all the information required to understand and manage Db2 system functions. The course describes and explains the installation and tailoring of the Db2 system and its attachments, system security, problem determination, system recovery and performance issues.

     

    On successful completion of this course you will be able to:

    • describe the address space structure and components of a Db2 subsystem
    • understand the Db2 installation process
    • identify Db2 functions that best suit the requirements of their site
    • implement security for the Db2 system
    • understand and implement Db2 system and data recovery and restart procedures
    • understand the control and use Db2 trace information to perform system and application tuning
    • understand the basic problem determination tools.

     

    Audience

    System Programmers, technical DBAs and other technical support personnel responsible for implementing and/or managing a Db2 for z/OS system.


Outline

Db2 System Architecture

Db2 System Installation, Migration & Modification

Connecting to Db2

Db2 Security Administration

Db2 Logging

Db2 Data Recovery

Db2 Shutdown, Startup & Recovery

Db2 Monitoring & Control

Problem Determination

Performance Overview

Prerequisites

A working knowledge of TSO/ISPF and a basic understanding of SQL and Db2 objects (databases, tables, indexes, etc.) used in Db2 systems.