Db2 for z/OS: Systems Administration

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.

Prerequisites

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

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


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

Program Details
Duration 3 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom


Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.

Contact