Introduction – Overview of DB2
The Sample Databases – Employees and Departments
Overview of DB2 SQL – the SELECT statement: WHERE clause
Basic SPUFI usage

• Computer Exercise: Basic SELECTs

DB2 environment overview
DB2 address spaces
DB2 interfaces
DB2 objects
DB2 catalog tables: SYSDATABASE, SYSTABLESPACE, SYSTABLES , SYSCOLUMNS, SYSINDEXES, SYSPACKAUTH, SYSPLANAUTH

• Computer Exercise:  Querying the Catalog Tables

Application development control flow overview
BIND/REBIND/FREE
Locks and locking
Authorizing Users
Executing a Program
Common Problems

• Computer Exercise:  BINDing and RUNning a DB2 Program

Backup and recovery
DB2 logs
COMMIT / ROLLBACK
DB2 utilities
DB2 utilities: COPY and MERGECOPY
DB2 catalog table: SYSCOPY
DB2 utilities: RECOVER
DB2 utilities: MODIFY

• Computer Exercise:  Backup and Recover

DB2 utilities: LOAD
DB2 utilities: REORG, RUNSTATS
DB2 utilities: QUIESCE, CHECK, REPORT
Utility related DB2 commands
Restarting utilities
Common problems

• Computer Exercise:  Other Utilities

Threads
Thread related commands
Trace related commands
Database related commands
DB2 manuals
SQLCODES, abend codes, reason codes, DSN messages
Problem resolution

• Computer Exercise: DB2 Commands

DB2 security
GRANT and REVOKE
Privileges and GRANT option
DB2 catalog tables for security
QMF overview
DB2 VSAM files
Application performance monitoring – EXPLAIN

• Optional Computer Exercise:  QMF