Db2 for z/OS Database Administration

PT3554
Training Summary
This course is designed to provide the student with the knowledge to effectively and efficiently design, create and maintain Db2 databases using up to and including version 12 of Db2 for z/OS. The student will learn how to use Entity Relationship Modeling techniques to design and normalize a relational database. They will demonstrate how to define Db2 objects, including Databases, Storage Groups, Tablespaces, Tables, including Temporal and Hash organization, Indexes, Views, Synonyms, Materialized Query Tables, Clone Tables and Aliases. The student will also develop skills to load, modify, backup, and recover Db2 data using Db2 utilities.
Prerequisites
Before taking this course, students should be familiar with Db2 concepts. Students should also have experience with SQL data manipulation language and experience using TSO/ISPF and JCL.
Duration
5 Days/Lecture & Lab
Audience
This course is intended for entry level or future Db2 database administrators or application programmers who need to acquire the essential skills required to administer a Db2 database.
Course Topics
  • Relational Database Design, including Entity Relationship Modeling techniques and Data Normalization
  • Db2 Overview and Storage Concepts
  • Referential integrity
  • Db2 objects
  • Creating Databases, Storage Groups, Tablespaces, including segmented and partitioned, Tables, Clone
  • Tables, Materialized Query Tables, Indexes, including cluster and non-cluster, Views, Synonyms and Aliases
  • VSAM file allocation options
  • Overview of Global Resource Serialization Concepts
  • Use of Db2 utilities to load, reorganize, perform backup and recovery operations
  • Utility Performance Considerations
  • Program Preparation, Bind and Locking
  • Implementing Security

Related Scheduled Courses