z/OS Overview and Db2 z/OS Basics for DBAs

Summary

This course is designed to teach new z/OS Database Administrators the z/OS environment and concepts. Students will gain a working knowledge of TSO, ISPF and JCL. The lecture components and hands-on labs will give each student the opportunity to understand and use the basic facilities of the z/OS environment.

The second part of this course focuses on introducing the student to database administration for Db2 z/OS, as well as best practices used to write queries using Db2 SQL up to and including version 11 of Db2 for z/OS. The student will demonstrate how to effectively and efficiently use SQL to extract and manipulate data in Db2 database objects, with an emphasis on performance considerations.

Prerequisites

There are no prerequisites for this course.

Duration

5 Days/Lecture & Lab

Audience

This course is intended for personnel who are new to the MVS operating system or those who are seeking a refresher course in basic to intermediate JCL programming execution.

Topics

• Operating system terminology
• Introduction to dataset storage
• TSO/ISPF introduction
• ISPF hierarchy
• ISPF commands
• Using SDSF to view job output
• Coding the JCL JOB and EXEC statements
• Coding JCL DD statements
• Db2 Concepts, Terminology and Storage Concepts
• Basic SELECT using SELECT, INSERT, UPDATE, DELETE, TRUNCATE and MERGE
• Advanced SQL
• Writing SQL Queries for Best Performance

Related Scheduled Courses