DB2 Data Base Administration - Topical Outline

Introduction to DB2 Data Base Design
Relational Architecture
Data Base Design Activities
Entity-relationship Model
Normalization And Normal Forms
   Exercise: Designing and normalizing a Data Base

DB2 Architecture
DB2 Objects - Databases, Storage Groups, Table Spaces, Tables
Buffer Pools
CREATE DATABASE
CREATE STOGROUP
CREATE TABLESPACE
VSAM File Allocation, Freespace, Locksize
Data Compression
Partitioned Table Spaces
CREATE TABLE
DB2 Data Types
DROP
   Computer Exercise: Creating DB2 Objects - Table Spaces and Tables

Inter-table consistency
Referential Integrity
DB2 Objects - Indexes
CREATE INDEX
Indexes - Structure, Clustering, Performance
DB2 Objects - Views, Synonyms
CREATE VIEW
CREATE SYNONYM
     Computer Exercise: Creating DB2 Objects: Indexes, Keys, and Views

Loading Data into Tables - LOAD Utility
INSERT
   Computer Exercise: Loading Tables

Concurrency
Locking: Locks, Claim/Drain, and Lock Avoidance
Explicit Locking Facilities
DB2 Catalog Tables
   Computer Exercise: Querying the Catalog Tables

Page Space Structures
Space Estimates
   Exercise: Estimating Space for a Data Base

Documenting Tables and Columns - COMMENT and LABEL
Modifying Data Base Designs - ALTER, DROP and re-CREATE
DB2 Utilities: REORG
   Computer Exercise: Revising DB2 Objects

Partition Independence
DB2 Utilities: RUNSTATS, MODIFY STATISTICS, STOSPACE
DB2 Commands
   Computer Exercise: RUNSTATS and Commands

Backup, Recovery, and the DB2 Log
DB2 Utilities: COPY, MERGECOPY, and COPYTOCOPY
DB2 Catalog Tables - SYSCOPY
DB2 Utilities: RECOVER, MODIFY, CHECK
DSN1COPY Service Aid
   Computer Exercise: Backup and Recovery

Utility Control Statements
    EXEC SQL
    LISTDEF
    OPTIONS
    TEMPLATE
DB2 Utilities: UNLOAD
    Computer Exercise: Utility Control Statements and UNLOAD

Tuning for Performance
    Logical and Physical Design
    Programming Considerations
   Computer Exercise: Querying the Catalog Tables for Performance

DB2 Security
GRANT and REVOKE
Table, Column, Data Base, Plan, Use, System and Implicit Privileges
DB2 Catalog Tables for Authorization
   Computer Exercise: Authorization

Exit Routines
Other Utilities
Distributed Data - Multisite Update
Other Topics

Course information: G-570 / 5 Days   These Materials © Copyright 2007 by Hunter Cobb    V8.x

Course Objectives
Course description
Home page

this page last updated: 07 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.