DB2 11 for zOS Database Administration Workshop Part 2 CV843G

Duration: 
3 days
Codes: 
CV843G
Versions: 
2,11

Overview

This course teaches database administrators various features they must be familiar with as DB2 11 for z/OS Database Administrators. These include program preparation, online schema changes, user defined functions, archive-enabled and temporal tables, partition management, stored procedures, and triggers. The course includes many hands-on demonstrations which give the students experience with the included topics. Additionally, there is information on other features in the course appendices, including schemas and user defined data types, clone tables, materialized query tables, large objects, global variables, and row permissions and column masks. This course is a follow-on course to CV832 – IBM DB2 11 for z/OS Database Administration Workshop Part 1. Note: This course is 3 days in length. If the instructor has time, he can cover the optional appendices as desired.

Audience

Database Administrators and System Programmers who would like to get further insight into database administration tasks.

Skills Gained

  • Introduce program preparation and the use of packages
  • Discuss immediate and pending online schema changes
  • Utilize UDFs
  • Utilize archive enabled tables
  • Utilize temporal tables
  • Manage partitions
  • Utilize Stored Procedures
  • Work with Triggers

Prerequisites

DB2 11 for z/OS Database Administration Part 1 (CV832) or equivalent experience or knowledge.

Course Outline

  • 1: Program preparation and the use of packages part 1
  • 2: Online schema changes part 1
  • 3: Online schema changes part 2
  • 4: UDFs
  • 5: Archive-enabled tables
  • 6: Temporal tables
  • 7: Partition management part 1
  • 8. Partition management part 2
  • 9. Stored procedures part 1
  • 10. Stored procedures part 2

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Somerset Bath3 2250 £2250 2020-02-17