IBM CV844G - Db2 12 for z/OS Basic Database Administration

Course Outline

Preface

• Course Overview
• Intended Audience
• Course Objectives
• Prerequisites

Unit 1 - Db2 Relational database concepts

• Relational Database design
• Data access
• Interacting with Db2Catalog 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

Appendix A - Demonstration solutions

Objective

Please refer to course overview

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

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.