Technologies / Data & Analytics

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

The z/OS and DB2 Basics for DB2 for z/OS DBA Beginners training covers basic DB2 database administration skills in a z/OS environment, including TSO/E, ISPF, SQL, JCL and DB2 tools.

Issues

Describing several services provided in a z/OS environment
Explanation of loads in a batch environment
Explaining the burden in the online environment
Describing professional roles in a z/OS environment
Login to TSO/E
Navigating the TSO/E and ISPF
Using TSO commands
Configuring and using JCL (Job Control Language)
Use of SDSF
Describing the different types of data sets in a z/OS environment
Assign datasets and display information about datasets and their contents
Create and modify the contents of data sets
Providing an overview of the DB2 environment 9
Describing and using DB2 objects
Describing and using several DB2 tools
Describing the DB2I (DB2 Interactive Facility) environment.
Using SPUFI (SQL Processing Using File Input) to create and execute SQL code
Configuring and executing DB2 commands
Understanding DB2 logging
Describing the DB2 program preparation process
Understanding DB2 startup and shutdown
Understand and use DB2 recovery strategies

Who is this training for?

This basic DB2 course is designed 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

Training program

(01:00) Unit 1: Introduction
(01:30) Unit 2: TSO/E and ISPF
(01:00) Exercise 1: TSO and ISPF
(00:15) Exercise 1 - overview
(01:00) Unit 3: Data Sets (Data Sets and Sequential Data Sets)
(01:00) Exercise 2: Sequential data sets
(00:15) Exercise 2 - overview
(01:00) Unit 3: Data sets (partitioned data sets)
(01:00) Exercise 3: Partitioned data sets
(00:15) Exercise 3 - overview
(00:45) Unit 3: Data sets (VSAM data sets)
(00:30) Exercise 4: VSAM data sets
(00:15) Exercise 4 - overview
(01:30) Unit 4: JCL and SDSF
(01:30) Exercise 5: JCL and SDSF
(00:15) Exercise 5 - overview
(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) Overview of Exercise 6
(01:30) Unit 7: DB2 objects (databases and tablespaces)
(00:45) Exercise 7: Databases and tablespaces
(00:15) Overview of Exercise 7
(01:30) Unit 7: DB2 objects (tables, indexes and views)
(00:45) Exercise 8: Tables, indexes and views
(00:15) Overview of exercise 8
(01:00) Unit 7: DB2 objects (qualified names, creating classified objects and SQL statements)
(00:30) Exercise 9: Qualified names, creating secret objects and SQL statements
(00:15) Overview of exercise 9
(01:30) Unit 8: DB2 system
(00:45) Exercise 10: DB2 system
(00:15) Overview of exercise 10
(02:00) Unit 9: DB2 commands and program preparation
(00:45) Exercise 11: DB2 Commands
(00:15) Overview of exercise 11
(02:00) Unit 10: DB2 Tools.
(01:00) Exercise 12: DB2 tools
(00:15) Overview of exercise 12
(01:15) Unit 11: Shutting down, starting up and recovering DB2
(00:45) Exercise 13: DB2 recovery
(00:15) Overview of Exercise 13
(00:30) Unit 12: Course Summary

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Your Learning Path

z/OS and DB2 Basics for DB2 for z/OS DBA BeginnersCurrent training

Db2 12 for zOS: Basics for DBA BeginnersPowiązane szkolenie

Frequently asked questions

Who is the z/OS and DB2 Basics for DB2 for z/OS DBA Beginners training for?

This training is designed for professionals looking to develop skills in z/os and db2 basics for db2 for z/os dba beginners. Required level: beginner.

How long is the z/OS and DB2 Basics for DB2 for z/OS DBA Beginners training?

The training lasts 5. Available in online or on-site format.

Will I receive a certificate?

Yes — every participant receives a completion certificate confirming acquired competencies. EITT holds ISO 9001 accreditation.

Can this training be conducted for a closed group?

Yes — we offer dedicated closed trainings for companies. We customize the program to your team's needs. Contact us for an individual quote.