Follow Us :

CV83GB DB2 9 for z/OS Database Administration Workshop Part 1

Course_Reference: 
CV83GB
Manufacturer: 
20
Training_Provider: 
0
Summary: 

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, the bind process, database utilities such as LOAD and REORG, and security considerations.

PreRequisites: 

Before taking this course, 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 (CE03) and SQL Workshop (CE12), or have equivalent experience.

Audience: 

Future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.

Objectives: 

  • Define and maintain the objects that make up a DB2 database
  • Resolve referential and check constraint violations
  • Load external sequential input data into DB2 tables
  • Gather statistics about DB2 data
  • Reorganize DB2 data
  • Unload DB2 data in external format
  • Recover a damaged table space to current
  • Compress data
  • Bind a DB2 application program
  • Control access to DB2 objects
  • Describe basic DB2 serialization concepts

Introduction

Setting up a DB2 database

  • Overview of setting up a DB2 database
  • Storage groups, databases, and table spaces
  • Tables
  • Data compression
  • Views, synonyms, and aliases
  • Materialized Query Tables
  • Indexes
  • Additional information

Referential integrity

  • Referential integrity
  • Informational RI constraints
  • Identity columns and sequences

Getting data into and out of DB2

  • SQL INSERT, DELETE, and UPDATE
  • Introduction to utilities
  • LOAD utility
  • Ensuring referential and check constraints
  • UNLOAD utility

Keeping your DB2 data in good shape

  • RUNSTATS
  • REORG
  • Real time statistics

Application data recovery basics

Program preparation / bind

Security

Serialization

Keywords: 
DB2,DB2 9,Database Administration,DB2 9 Workshop,Database Administration Workshop

Software Vendor

IT Technical

Business Skills