Db2 12 for z/OS Basic Database Administration-CV844G

Course Overview

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

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