Description
Course on Db2 13 for z/OS Basic Database Administration
Mode: Online and in-person
Duration in days: 3
Target Audience:
- Students who will be performing the role of Db2 for z/OS database administrators who need to acquire the basic skills required to administer a Db2 database.
Desired Prerequisites:
- Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF
- Familiarity with SQL data manipulation statements (SELECT, INSERT, UPDATE, and DELETE) to access and change the contents of Db2 tables
Course Agenda
Preface
- Course Overview
- Intended Audience
- Course Objectives
- Prerequisites
Unit 1 – Db2 Relational database concepts
- Relational Database design
- Data access
- Interacting with Db2bull; Catalog and directory
Unit 2 – SQL and SPUFI
- SQL SELECT statement review
- SQL INSERT, UPDATE, DELETE review
- SQL COMMIT and ROLLBACK review
- Joining tables
- Executing SQL using SPUFI
Unit 3 – Db2 objects (Storage groups, databases, and table spaces)
- Object concepts
- Storage Groups
- Databases
- Table Spaces
Unit 4 – Db2 Objects
- Tables
- Indexes
- Views
Unit 5 – Utilities
- Utility Categories
- Load Utility
- Check Data Utility
- Unload Utility
- Runstats Utility
- Reorg Utility
Unit 6 – Commands and program preparation
- Db2 Command Structure
- Display Command
- Archiving Logs
- Stop and Start Commands
- Executing Commands
- Program Preparation
Unit 7 – The Db2 system
- System Parameters (zParms)
- Address Spaces
- System Databases
- Buffer Pools
- Logging
- Integrity
- Security
Unit 8 – Db2 Shutdown, startup, and recovery
- Start and Stop Commands
- Db2 Shutdown Process
- Db2 Startup Phases
- System Recovery
- Object Recovery
- Copy Utility
- Recover Utility
Instructors specialized in IBM, Red Hat, SUSE and Canonical
At SIXE, the quality of our training is reflected in the experience and knowledge of our instructors. Each IBM course is taught by highly qualified and certified professionals. Among our instructors, we have IBM Champions with years of industry experience and a deep understanding of IBM technologies and solutions. Our instructors not only possess advanced theoretical knowledge but also significant practical experience of more than 15 years in the development and implementation of solutions in real enterprise environments.
Our experts are committed to educational excellence and offer personalized training to address the specific challenges faced by participants. Each session is enriched with practical case studies and real-life examples, ensuring that the knowledge acquired is directly applicable in the workplace.
