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

Overview

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

The course materials cover DB2 11 for z/OS.

Learning Journeys or Training Paths that reference this course:

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.

Key topics

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

  • Describe several services provided in a z/OS environment
  • Explain workloads in the batch environment
  • Explain workloads in the online environment
  • Describe job roles in a z/OS environment
  • Log On to TSO/E
  • Navigate TSO/E and ISPF
  • Use TSO commands
  • Setup and utilize JCL (Job Control Language)
  • Utilize SDSF
  • Describe the different types of data sets in a z/OS environment
  • Allocate data sets and list data set information and content
  • Create and modify data set content
  • Give an overview of the DB2 9 environment
  • Describe and utilize DB2 Objects
  • Describe and utilize several DB2 Utilities
  • Describe the DB2I (DB2 Interactive Facility) environment
  • Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
  • Setup and execute DB2 Commands
  • Understand DB2 Logging
  • Describe DB2 program preparation process
  • Understand DB2 startup and shutdown
  • Understand and utilize DB2 recovery strategies

Related Articles:

IBM Training Blog:

Enroll

You can enroll in an instructor-led classroom at different geographic locations, instructor-led online course in any timezone or a self-paced online course.

This class has been identified by our Global Training Partner as "Guaranteed to run". View the terms and conditions for full details.

Start Date GTR Country City Duration Language Partner Action
Italy Torino 48 Hours Italian Global Knowledge/PR.ES. srl

Enroll



Skip Sign in

Italy Milano 48 Hours Italian Global Knowledge/PR.ES. srl

Enroll



Skip Sign in

Italy Roma 48 Hours Italian Global Knowledge/PR.ES. srl

Enroll



Skip Sign in

Indonesia Jakarta, ID 40 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Singapore Singapore, SG 40 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Netherlands Arrow ECS Houten 40 Hours Dutch Arrow ECS

Enroll



Skip Sign in

Spain Arrow ECS 40 Hours Spanish Arrow ECS

Enroll



Skip Sign in

Spain Arrow ECS 40 Hours Spanish Arrow ECS

Enroll



Skip Sign in

Mexico Ciudad De Mexico 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Mexico Monterrey 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Mexico Guadalajara 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Colombia Bogota 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Colombia Medellin 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Peru Lima 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Chile Santiago 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Argentina Buenos Aires 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Brazil Rio De Janeiro 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Brazil Sao Paulo 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Venezuela Caracas 32 Hours Spanish Global Knowledge

Enroll



Skip Sign in

Denmark København - Ballerup 40 Hours English Arrow ECS

Enroll



Skip Sign in

France Paris 40 Hours French Arrow ECS

Enroll



Skip Sign in

France Paris 40 Hours French Arrow ECS

Enroll



Skip Sign in

Austria Vienna, AT 40 Hours German Ingram Micro

Enroll



Skip Sign in

Spain Barcelona, ES 40 Hours Spanish Ingram Micro

Enroll



Skip Sign in

Czech Republic Prague, CZ 40 Hours English Ingram Micro

Enroll



Skip Sign in

Slovakia Bratislava, SK 40 Hours English Ingram Micro

Enroll



Skip Sign in

Serbia Beograd, RS 40 Hours English Ingram Micro

Enroll



Skip Sign in

Spain Barcelona, ES 40 Hours Spanish Ingram Micro

Enroll



Skip Sign in

Czech Republic Prague, CZ 40 Hours English Ingram Micro

Enroll



Skip Sign in

Slovakia Bratislava, SK 40 Hours English Ingram Micro

Enroll



Skip Sign in

Poland Warsaw, PL 40 Hours English Ingram Micro

Enroll



Skip Sign in

Slovenia Ljubljana, SI 40 Hours English Ingram Micro

Enroll



Skip Sign in

France Paris, FR 40 Hours French Ingram Micro

Enroll



Skip Sign in

Hungary Budapest, HU 40 Hours English Ingram Micro

Enroll



Skip Sign in

Slovenia Ljubljana, SI 40 Hours English Ingram Micro

Enroll



Skip Sign in

Germany Frankfurt 40 Hours German Ingram Micro

Enroll



Skip Sign in

Serbia Beograd, RS 40 Hours English Ingram Micro

Enroll



Skip Sign in

Portugal Lisboa, PT 40 Hours Portuguese Ingram Micro

Enroll



Skip Sign in

Switzerland Zurich, CH 40 Hours German Ingram Micro

Enroll



Skip Sign in

Switzerland Zurich, CH 40 Hours German Ingram Micro

Enroll



Skip Sign in

Hungary Budapest, HU 40 Hours English Ingram Micro

Enroll



Skip Sign in

Portugal Lisboa, PT 40 Hours Portuguese Ingram Micro

Enroll



Skip Sign in

Austria Vienna, AT 40 Hours German Ingram Micro

Enroll



Skip Sign in

Germany Frankfurt 40 Hours German Ingram Micro

Enroll



Skip Sign in

Poland Warsaw, PL 40 Hours English Ingram Micro

Enroll



Skip Sign in

Italy Rome, IT 40 Hours Italian Ingram Micro

Enroll



Skip Sign in

France Paris, FR 40 Hours French Ingram Micro

Enroll



Skip Sign in

Ireland Dublin 40 Hours English Ingram Micro

Enroll



Skip Sign in

Italy Rome, IT 40 Hours Italian Ingram Micro

Enroll



Skip Sign in

India Bangalore 40 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

India Bangalore 40 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

India Bangalore 40 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

Singapore Singapore 40 Hours English LearnQuest

Enroll



Skip Sign in

Switzerland Glattbrugg 40 Hours German LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Switzerland Genève 40 Hours French LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Switzerland Genève 40 Hours French LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Poland Warszawa 40 Hours Polish TechData Inc.

Enroll



Skip Sign in

Spain Madrid 40 Hours Spanish TechData Inc.

Enroll



Skip Sign in

United Kingdom Bracknell 40 Hours English TechData Inc.

Enroll



Skip Sign in

United Kingdom London 40 Hours English TechData Inc.

Enroll



Skip Sign in

Italy Bologna 40 Hours Italian LearnQuest/Overnet Solutions Ltd.

Enroll



Skip Sign in

Italy Roma 40 Hours Italian LearnQuest/Overnet Solutions Ltd.

Enroll



Skip Sign in

Australia Perth 40 Hours English TechData Inc.

Enroll



Skip Sign in

Switzerland Genève 40 Hours French TechData Inc.

Enroll



Skip Sign in

Germany Krefeld 40 Hours German TechData Inc.

Enroll



Skip Sign in

Austria Wien 40 Hours German TechData Inc.

Enroll



Skip Sign in

Italy Roma 40 Hours Italian TechData Inc.

Enroll



Skip Sign in

Italy San Giuliano M.se 40 Hours Italian TechData Inc.

Enroll



Skip Sign in

Romania Bucuresti 40 Hours Romanian TechData Inc.

Enroll



Skip Sign in

Switzerland Rotkreuz 40 Hours German TechData Inc.

Enroll



Skip Sign in

Indonesia Jakarta 40 Hours English TechData Inc.

Enroll



Skip Sign in

Switzerland Zürich 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Switzerland Zürich 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Switzerland Ostermundingen 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Switzerland Zürich 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Austria Wien 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Austria Wien 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Austria Wien 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Austria Wien 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany Holzgerlingen 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany Hamburg 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany München 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany Stuttgart 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany Berlin 40 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

If you are interested in a custom or private delivery of this content, please contact a GTP about delivery in your country.

Start Date My Time Zone GTR Country Duration Language Partner Action
Worldwide40 HoursEnglishArrow ECS

Enroll



Skip Sign in

Worldwide40 HoursEnglishArrow ECS

Enroll



Skip Sign in

Worldwide40 HoursEnglishIngram Micro

Enroll



Skip Sign in

Worldwide40 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide40 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide40 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide40 HoursEnglishLearnQuest

Enroll



Skip Sign in

Worldwide40 HoursFrenchLearnQuest

Enroll



Skip Sign in

Worldwide40 HoursGermanLearnQuest

Enroll



Skip Sign in

Worldwide40 HoursEnglishLearnQuest

Enroll



Skip Sign in

Worldwide40 HoursEnglishLearnQuest

Enroll



Skip Sign in

Worldwide40 HoursEnglishIngram Micro

Enroll



Skip Sign in

Worldwide40 HoursEnglishIngram Micro

Enroll



Skip Sign in