TRAINING

Enroll Now

IBM DB2 Training  

DB2 training is designed to store, analyze and retrieve the data efficiency. DB2 is a product from IBM.  DB is stands for Database. DB2 is the extensions with the help of object oriented features and non relational structures with XML. It is a relational Database management system.

Outline

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

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.

Course 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

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

• Welcome
• Introduction
• TSO/E and ISPF
1. TSO and ISPF
2. Review
• Data Sets (Data Sets and Sequential Data Sets)
1. Sequential Data Sets
2. Review

Day 2

• Data Sets (Partitioned Data Sets)
1. Partitioned Data Sets
2. Review
• Data Sets (VSAM Data Sets)
1. VSAM Data Sets
2. Review
• JCL and SDSF
1. JCL and SDSF
2. Review

Day 3

• DB2 Relational Database Concepts
• Structured Query Language (SQL) and SPUFI
1. SQL and SPUFI
2. Review
• DB2 Objects (Databases and Table Spaces)
1. Databases and Table Spaces
2. Review
• DB2 Objects (Tables, Indexes, and Views)
1. Tables, Indexes, and Views
2. Review

Day 4

• DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
1. Qualified Names, Implicit Object Creation, and SQL Statements
2. Review
• The DB2 System
1. The DB2 System
2. Review
• DB2 Commands and Program Preparation
1. DB2 Commands
2. Review

Day 5

• DB2 Utilities
1. DB2 Utilities
2. Review
• DB2 Shutdown, Startup, and Recovery
1. DB2 Recovery
2. Review