Home About Courses Schedule Services Webinars Contact Search

Db2 for z/OS Systems Fundamentals

SEE SCHEDULE

Duration: 2.0 days

Method: Instructor led, Hands-on workshops

Price: $1250.00

Course Code: DB5000



Audience

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

Description

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.

Objectives

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

Prerequisites

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

Topics

  1. Introduction
    • Db2 support of the Relational DBMS Model
    • Db2 Deliverables
    • Db2 Operational Environment
    • Personnel
  2. 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
  3. Db2 Commands and Utilities
    • Db2 Commands
    • Db2 Online Utilities
    • Db2 Offline Utilities
    • Service Aids
  4. SQL Language and Query Processing
    • Data Manipulation Language
    • Coding basic SQL Queries
    • Access Path Optimizer
    • SQL Access Paths and Performance
  5. Application Development and Support
    • Languages Supported
    • Embedded SQL Basics
    • Binds and Rebinds
    • What a Db2 Developer needs to know
  6. Systems Administration Overview
    • Critical Subsystem Structures
    • Critical Subsystem Resources
    • What a Systems Administration needs to know