Audience
Db2 Database Administrators who will be designing and managing databases on Db2 for z/OS.
Description
Starting with a logical data model we guide you through the implementation of a fully functional Db2 production database. During the hands-on workshops you will create basic database objects, use Db2 utilities to populate, manage and recover your objects and perform basic management and monitoring procedures. Physical Database Implementation and control are the key issues addressed by this course. The majority of the content concentrates on the Application DBAs role and responsibilities.
Objectives
Upon successful completion of this course, the student will be able to:
- Describe the Db2 System and Data Objects
- Create Db2 Database Objects
- Implement Db2 Naming Conventions
- Identify the Db2 System Objects impacted when creating Data Objects
- Manage Db2 Table Spaces and Index Spaces
- Use the Db2 Catalog to monitor your Db2 Databases
- Alter your Db2 Data Objects for performance and usability
- Populate and maintain Db2 Databases using Db2 utilities
- Prepare your Database for Recovery
- Perform basic Database Recovery
- Use Db2 commands to monitor Db2 databases
- Identify security authorization requirements
- Support your Development Group
Prerequisites
Introduction to Db2 & SQL coding basics (DB1000), TSO/ISPF, MVS JCL (MF1010)