Training offering

DB2 10 for z/OS Database Administration Part 2

Overview

This course is a continuation of course DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) and is designed to teach you how to perform additional database administration tasks.

This course replaces DB2 for z/OS Database Administration Workshop Part 2 (CV841). This is the Classroom version of Instructor-led online course DB2 10 for z/OS Database Administration Part 2 - ILO (3V842).

Public

This intermediate course is for Database Administrators and System Programmers who would like to get insight into database administration tasks. The course lab exercises are performed on a DB2 10 for z/OS environment.

Prerequisits

You should have attended course:

• DB2 10 for z/OS Database Administration Workshop Part 1 (CV831)

or have attained a similar level of experience.

Topics

Day 1

• Welcome
• Unit 1: Transition from DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) to DB2 for z/OS Database Administration Workshop Part 2 (CV841)
• Unit 2: Program Preparation and Use of Packages
• Exercise 1: Program Preparation
• Unit 3: Online Schema Changes
• Exercise 2: Online Schema Changes

Day 2

• Unit 4: Clone Tables
• Exercise 3: Clone Tables
• Unit 5: Partition Management
• Exercise 4: Partition Management
• Unit 6: UDTs and UDFs
• Exercise 5: UDTs and UDFs

Day 3

• Unit 7: Stored Procedures
• Exercise 6: Stored Procedures
• Unit 8: Triggers
• Exercise 7: Triggers
• Unit 9: Large Objects
• Exercise 8: LOBs