Technologies / Data & Analytics

Introduction to IBM DB2 for zOS for Systems and Operations Personnel

Learn the basics of DB2 management for z/OS. Learn DB2 objects, SQL, DB2 commands, DB2 tools, and startup and recovery processes. Ideal for novice DB2 administrators.

Issues

Overview of the DB2 environment 9
Description and use of DB2 objects
Description and use of several DB2 tools
Description of the DB2I (DB2 Interactive Facility) environment.
Using SPUFI (SQL Processing Using File Input) to create and execute SQL
Configuring and executing DB2 commands
Understanding DB2 logging
Description of the DB2 program preparation process
DB2 startup and shutdown
Understand and use DB2 recovery strategies

Who is this training for?

The course is designed for novice DB2 for z/OS database administrators who need to acquire the basic skills necessary to administer a DB2 database in a z/OS environment

Prerequisites

z/OS, TSO, ISPF and SDSF
Sequential, partitioned and VSAM data sets
and basic JCL

Training program

Unit 1: Overview of z/OS prerequisites
Exercise 1: Connecting to z/OS and creating data sets
Overview of exercise 1
Unit 2: DB2 relational database concepts
Unit 3: Structured Query Language (SQL) and SPUFI
Exercise 2: SQL and SPUFI
Overview of exercise 2
Unit 4: DB2 objects (databases and tablespaces).
Exercise 3: Databases and tablespaces
Overview of exercise 3
Unit 4: DB2 objects (tables, indexes and views)
Exercise 4: Tables, indexes and views
Overview of exercise 4
Unit 4: DB2 objects (qualified names, creating secret objects and SQL statements)
Overview of Exercise 5: Qualified Names, Classified Object Creation, and SQL statements
Overview of Exercise 5
Unit 5: DB2 system
Exercise 6: DB2 system
Overview of Exercise 6
Unit 6: DB2 commands and program preparation
Exercise 7: DB2 Commands
Overview of Exercise 7
Unit 7: DB2 Tools
Exercise 8: DB2 tools
Overview of exercise 8
Unit 8: Shutting down, starting up and recovering DB2
Exercise 9: DB2 recovery
Overview of exercise 9
Unit 9: 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

Frequently asked questions

What are the prerequisites for this training?

For Introduction to IBM DB2 for zOS for Systems and Operations Personnel we recommend: z/OS, TSO, ISPF and SDSF; Sequential, partitioned and VSAM data sets; and basic JCL.

What is the format and duration of this training?

The training lasts 3 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.

Who is this training designed for?

This training is designed for: The course is designed for novice DB2 for z/OS database administrators who need to acquire the basic skills necessary to administer a DB2 database in a z/OS environment.