DB2 11 for z/OS Database Administration Workshop Part 1 – CV832GCR
Enrol Details
Course Code: CV832G Brand: HDM – Db2 for z/OS Category: Analytics Skill Level: Intermediate Duration: 40H Modality:CR Audience
This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.
Prerequisites
You should be able to:
_x000D_
_x000D_
- _x000D_
- Design a relational table
- Describe the SQL data manipulation statements to access and change the contents of DB2 tables
_x000D_
_x000D_
_x000D_
_x000D_
You should also take DB2 Family Fundamentals (CE031G) and DB2 SQL Workshop (CE121G), or have equivalent experience.
Short Summary
This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database. Overview
This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.
_x000D_
_x000D_
Note: This course material is at the DB2 11 for z/OS level.
Topic
- Setting up a DB2 database
- Referential integrity
- Getting data into and out of DB2
- Keeping your DB2 data in good shape
- Application data recovery basics
- Program preparation and Bind
- Security
- Serialization
The course includes extensive machine exercises.
Objectives
- _x000D_
- Implement a DB2 database design
- Use database utilities to load and reorganize data
- Define and implement a DB2 database recovery strategy
- Control access to database using DB2 authorization facilities
_x000D_
_x000D_
_x000D_
_x000D_