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