z/OS and DB2 Basics for DB2 for z/OS DBA Beginners – CV041GCR

image_pdfCourse Outline PDF

Enrol   Details

Course Code: CV041G Brand: HDM – Db2 Category: Analytics Skill Level: Basic Duration: 40H Modality:CR      Audience

This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

  Prerequisites

There are no formal prerequisites for this course.

  Short Summary

This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.  Overview

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:

_x000D_
_x000D_

    _x000D_

  • TSO/E and ISPF

    • _x000D_

  • Data sets

    • _x000D_

  • DB2 Objects

    • _x000D_

  • Structured Query Language

    • _x000D_

  • DB2 Commands

    • _x000D_

  • JCL and SDSF

    • _x000D_

  • DB2 Utilities

    • _x000D_

  • DB2 Logging

    • _x000D_

  • DB2 Program Preparation

    • _x000D_

_x000D_
_x000D_

The course materials cover DB2 11 for z/OS.

  Topic

CONTENTS :

  • Introduction
  • TSO/E and ISPF
  • Data Sets
  • JCL and SDSF
  • DB2 Relational Database Concepts
  • Structured Query Language (SQL) and SPUFI
  • DB2 Objects
  • The DB2 System
  • DB2 Commands and Program Preparation
  • DB2 Utilities
  • DB2 Shutdown, Startup, and Recovery
  • Course Summary

AGENDA :

Day 1

  • (00:30) Welcome
  • (01:00) Unit 1: Introduction
  • (01:30) Unit 2: TSO/E and ISPF
  • (01:00) Exercise 1: TSO and ISPF
  • (00:15) Exercise 1 Review
  • (01:00) Unit 3: Data Sets (Data Sets and Sequential Data Sets)
  • (01:00) Exercise 2: Sequential Data Sets
  • (00:15) Exercise 2 Review

Day 2

  • (01:00) Unit 3: Data Sets (Partitioned Data Sets)
  • (01:00) Exercise 3: Partitioned Data Sets
  • (00:15) Exercise 3 Review
  • (00:45) Unit 3: Data Sets (VSAM Data Sets)
  • (00:30) Exercise 4: VSAM Data Sets
  • (00:15) Exercise 4 Review
  • (01:30) Unit 4: JCL and SDSF
  • (01:30) Exercise 5: JCL and SDSF
  • (00:15) Exercise 5 Review

Day 3

  • (01:15) Unit 5: DB2 Relational Database Concepts
  • (01:15) Unit 6: Structured Query Language (SQL) and SPUFI
  • (00:45) Exercise 6: SQL and SPUFI
  • (00:15) Exercise 6 Review
  • (01:30) Unit 7: DB2 Objects (Databases and Table Spaces)
  • (00:45) Exercise 7: Databases and Table Spaces
  • (00:15) Exercise 7 Review
  • (01:30) Unit 7: DB2 Objects (Tables, Indexes, and Views)
  • (00:45) Exercise 8: Tables, Indexes, and Views
  • (00:15) Exercise 8 Review

Day 4

  • (01:00) Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
  • (00:30) Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements
  • (00:15) Exercise 9 Review
  • (01:30) Unit 8: The DB2 System
  • (00:45) Exercise 10: The DB2 System
  • (00:15) Exercise 10 Review
  • (02:00) Unit 9: DB2 Commands and Program Preparation
  • (00:45) Exercise 11: DB2 Commands
  • (00:15) Exercise 11 Review

Day 5

  • (02:00) Unit 10: DB2 Utilities
  • (01:00) Exercise 12: DB2 Utilities
  • (00:15) Exercise 12 Review
  • (01:15) Unit 11: DB2 Shutdown, Startup, and Recovery
  • (00:45) Exercise 13: DB2 Recovery
  • (00:15) Exercise 13 Review
  • (00:30) Unit 12: Course Summary

  Objectives

    _x000D_

  • Describe several services provided in a z/OS environment

    • _x000D_

  • Explain workloads in the batch environment

    • _x000D_

  • Explain workloads in the online environment

    • _x000D_

  • Describe job roles in a z/OS environment

    • _x000D_

  • Log On to TSO/E

    • _x000D_

  • Navigate TSO/E and ISPF

    • _x000D_

  • Use TSO commands

    • _x000D_

  • Setup and utilize JCL (Job Control Language)

    • _x000D_

  • Utilize SDSF

    • _x000D_

  • Describe the different types of data sets in a z/OS environment

    • _x000D_

  • Allocate data sets and list data set information and content

    • _x000D_

  • Create and modify data set content

    • _x000D_

  • Give an overview of the DB2 9 environment

    • _x000D_

  • Describe and utilize DB2 Objects

    • _x000D_

  • Describe and utilize several DB2 Utilities

    • _x000D_

  • Describe the DB2I (DB2 Interactive Facility) environment

    • _x000D_

  • Use SPUFI (SQL Processing Using File Input) to compose and execute SQL

    • _x000D_

  • Setup and execute DB2 Commands

    • _x000D_

  • Understand DB2 Logging

    • _x000D_

  • Describe DB2 program preparation process

    • _x000D_

  • Understand DB2 startup and shutdown

    • _x000D_

  • Understand and utilize DB2 recovery strategies

    • _x000D_

admin
0
Tags :
Call Now +27 12 023 1959