Home About Courses Schedule Services Webinars Contact Search

Db2 for z/OS Systems Fundamentals


Duration: 3 days

Method: Instructor led, Hands-on workshops

Price: $1920

Course Code: DB5000


System Administrators, Systems DBAs and Database Administrators who will be supporting Db2 for z/OS and require a working knowledge of the Db2 deliverables.


This workshop provides a comprehensive introduction to Db2 for z/OS for Db2 Administrators. The course begins with an overview of the environment and helps you understand the various roles that play an integral part of Db2 for z/OS Administration.


Upon successful completion of this course, the student will be able to:

  • Understand the Db2 for z/OS Environment
  • Perform basic Database Administration Functions
  • Use Commands and Utilities to manage Db2 Objects
  • Code and execute simple SQL Queries
  • Deploy and Implement Application Plans and Packages
  • Describe the responsibilities of Systems Administration


A working knowledge of TSO/ISPF, MVS JCL (MF1010).


  • I. Introduction
    • Db2 support of the Relational DBMS Model
    • Db2 Deliverables
    • Db2 Operational Environment
    • Personnel
  • II. Data Structures and Database Administration
    • Db2 Database Object
    • Object Types
    • Naming Conventions
    • Data Definition Language
    • Db2 Catalog and Directory
    • What a Database Administrator needs to know
  • III. Db2 Commands and Utilities
    • Db2 Commands
    • Db2 Online Utilities
    • Db2 Offline Utilities
    • Service Aids
  • IV. SQL Language and Query Processing
    • Data Manipulation Language
    • Coding basic SQL Queries
    • Access Path Optimizer
    • SQL Access Paths and Performance
  • V. Application Development and Support
    • Languages Supported
    • Embedded SQL Basics
    • Binds and Rebinds
    • What a Db2 Developer needs to know
  • VI. Systems Administration Overview
    • Critical Subsystem Structures
    • Critical Subsystem Resources
    • What a Systems Administration needs to know