Technologies / Data & Analytics

Db2 12 for zOS: Basics for DBA Beginners

Learn the basics of DB2 12 administration for z/OS. EITT training covers database management, table and index creation, and performance optimization.

Why choose this training?

Growing market demands mean that, technical competencies have become a critical asset. Learn the basics of DB2 12 administration for z/OS. EITT training covers database management, table and index creation, and performance optimization.

Upon completion, participants will be able to: Describe several services provided in a z/OS environment, Explain loads in a batch environment, Explain loads in an online environment, Describe professional roles in a z/OS environment. These competencies directly translate into higher effectiveness in IT projects.

This training is particularly valuable 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.

What makes our approach unique?

The EITT approach is based on hands-on experience and practical exercises. Over 5 days of intensive training, participants work on real-world examples and scenarios, ensuring not only theoretical understanding but practical application skills.

With over 2,500 trainings in our portfolio and a 4.8/5 participant rating, EITT is a trusted partner in IT competency development for organizations of all sizes. Our trainers are experienced practitioners who share up-to-date knowledge and proven solutions.

Looking for training tailored to your team’s needs? Contact us — we’ll prepare a program customized to your requirements.

Benefits

Describe several services provided in a z/OS environment
Explain loads in a batch environment
Explain loads in an online environment
Describe professional roles in a z/OS environment
Log in to TSO/E
Navigate the TSO/E and ISPF
Use TSO commands
Configure and use JCL (Job Control Language)
Use SDSF
Describe 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
Provide an overview of the Db2 environment 9
Describe and use Db2 objects
Describe and use several DB2 tools
Describe the Db2I (Db2 Interactive Facility) environment.
Use SPUFI (SQL Processing Using File Input) to create and execute SQL code
Configure and execute Db2 commands
Db2 Registration
Describe the process of preparing the Db2 program
Understand the startup and shutdown of Db2
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