Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

DB2 11 for zOS Database Administration Workshop Part 2

GK# 4538

Course 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.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $2195 CAD

    3 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

    From

    $2195 CAD

    3 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Program preparation and the use of packages
  • Immediate and pending online schema changes
  • Utilizing UDFs
  • Utilizing archive enabled tables
  • Utilizing temporal tables
  • Managing partitions
  • Utilizing Stored Procedures
  • Working with Triggers

Prerequisites

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

Who Needs To Attend

Database administrators and system programmers who would like to get further insight into database administration tasks.