Home > Vendors > ibm > cv842g

CV842G - IBM DB2 10 for z/OS Database Administration Part 2

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)

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

Execute program preparation steps including resolving common problems, defining collections and packages, and versioning of packages
Alter table characteristics such as data types of columns and identify the impact of making such changes
Alter indexes to add columns or to change the varying length or clustering characteristics of the index, and identify the impact of making such changes
React to the "Advisory Reorg" Database Exception Table state
Make appropriate decisions to successfully handle table space versions
Given the usage of the data, determine an appropriate option for dealing with the need for adding partitions or rebalancing data partitions
Determine the applicability and implement clone tables, user-defined distinct types, user-defined functions, stored procedures, triggers, and large objects

Content

Day 1

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

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

Audience

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.

Prerequisites

DB2 10 for z/OS Database Administration Workshop Part 1 (CV831)
or have attained a similar level of experience.

Certification

This course is not associated with any Certification.

Course Benefits

Career growth
Broad Career opportunities
Worldwide recognition from leaders
Up-to Date technical skills
Popular Certification Badges

Enquire Now

PLIjGa

By clicking "Submit", I agree to the Terms Of Use and Privacy Policy

➤