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 z/OS Database Administration Part 1

Acquire the basic skills required to administer a DB2 database.

GK# 1550 Vendor# CV832G

Course Overview

TOP

This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, and the bind process, database utilities such as LOAD and REORG, and security considerations.

Note: While class exercises are performed within a DB2 11 for z/OS environment, our expert instructors can provide guidance on all versions and their differences.

What You'll Learn

TOP
  • Implement a DB2 database design
  • Use database utilities to load and reorganize data
  • Define and implement a DB2 database recovery strategy
  • Control access to database using DB2 authorization facilities

Outline

TOP
Viewing outline for:

Classroom Live Outline

  • Setting up a DB2 database
  • Referential integrity
  • Getting data into and out of DB2
  • Keeping your DB2 data in good shape
  • Application data recovery basics
  • Program preparation and Bind
  • Security
  • Serialization

The course includes extensive machine exercises.

Prerequisites

TOP
  • Design a relational table
  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables

Who Should Attend

TOP

This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

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

Duration: 5 day

Virtual Classroom Live

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

Duration: 5 day

Request this course in a different delivery format.
Enroll