This course provides students with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities, & security considerations.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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

1

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

Audience

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.

Language

English

Prerequisites

You should be able to: Design a relational table; Describe the SQL data manipulation statements to access and change the contents of DB2 tables; You should also take DB2 Family Fundamentals (CE031G) and DB2 SQL Workshop (CE121G), or have equivalent experience.

$3,500

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...