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