Db2 13 for z/OS Basic Database Administration

Preface
• Course Overview
• Intended Audience
• Course Objectives
• Prerequisites

Unit 1 - Db2 Relational database concepts
• Relational Database design
• Data access
• Interacting with Db2
- 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

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.

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