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.
Duration
5 days. Hands on.
Course Objectives
DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:
- TSO/E and ISPF
- Data sets
- DB2 Objects
- Structured Query Language
- DB2 Commands
- JCL and SDSF
- DB2 Utilities
- DB2 Logging
- DB2 Program Preparation
The course materials cover DB2 11 for z/OS.
Course objectives include:
- 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
Course Content
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
Day 1
Welcome
Unit 1: Introduction
Unit 2: TSO/E and ISPF
Exercise 1: TSO and ISPF
Exercise 1 Review
Unit 3: Data Sets (Data Sets and Sequential Data Sets)
Exercise 2: Sequential Data Sets
Exercise 2 Review
Day 2
Unit 3: Data Sets (Partitioned Data Sets)
Exercise 3: Partitioned Data Sets
Exercise 3 Review
Unit 3: Data Sets (VSAM Data Sets)
Exercise 4: VSAM Data Sets
Exercise 4 Review
Unit 4: JCL and SDSF
Exercise 5: JCL and SDSF
Exercise 5 Review
Day 3
Unit 5: DB2 Relational Database Concepts
Unit 6: Structured Query Language (SQL) and SPUFI
Exercise 6: SQL and SPUFI
Exercise 6 Review
Unit 7: DB2 Objects (Databases and Table Spaces)
Exercise 7: Databases and Table Spaces
Exercise 7 Review
Unit 7: DB2 Objects (Tables, Indexes, and Views)
Exercise 8: Tables, Indexes, and Views
Exercise 8 Review
Day 4
Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements
Exercise 9 Review
Unit 8: The DB2 System
Exercise 10: The DB2 System
Exercise 10 Review
Unit 9: DB2 Commands and Program Preparation
Exercise 11: DB2 Commands
Exercise 11 Review
Day 5
Unit 10: DB2 Utilities
Exercise 12: DB2 Utilities
Exercise 12 Review
Unit 11: DB2 Shutdown, Startup, and Recovery
Exercise 13: DB2 Recovery
Exercise 13 Review
Unit 12: Course Summary