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

Days: 3 day
Price: $2295

Course Details

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.

Course Agenda

Day 1

  • Welcome
  • Unit 1: Transition from CV830 to 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

Details

Options