G570 DB2 Data Base Administration

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

Computer Exercise: Designing and Normalizing a Data Base

DB2 Architecture

DB2 Objects - Databases, Storage Groups, Table Spaces, Tables, Indexes, Synonyms, Aliases, Sequences

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

CREATE INDEX

CREATE VIEW

CREATE SYNONYM

CREATE ALIAS

CREATE SEQUENCE

CREATE SCHEMA

Computer Exercise: Creating DB2 Objects - Indexes, Keys, and Views

Loading Data into Tables - LOAD Utility

INSERT

MERGE

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

DB2 Utilities: CHECK, QUIESCE, REPORT

Computer Exercise: Check Utility and Space Estimates

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, REBUILD, MODIFY RECOVERY

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

User-Defined Functions

Triggers

Materialized Query Tables

G570 / 5 Days

Materials version: V8.x

Course Objectives
Course Description
Home page