Unit 1 - Db2 Relational database concepts
- Relational Database design
- Data access
- Interacting with Db2
- Catalog and directory
Unit 2 - SQL and SPUFI
- SQL SELECT statement review
- SQL INSERT, UPDATE, DELETE review
- SQL COMMIT and ROLLBACK review
- Joining tables
- Executing SQL using SPUFI
Unit 3 - Db2 objects (Storage groups, databases, and table spaces)
- Object concepts
- Storage Groups
- Databases
- Table Spaces
Unit 4 - Db2 Objects (Tables, indexes, and views)
- Tables
- Aliases
- Table constraints
- Primary key
- Foreign key
- Check
- Referential integrity
- Indexes
- Views
- Qualified names
- Implicit object creation
Unit 5 - Utilities
- Utility Categories
- Load Utility
- Check Data Utility
- Unload Utility
- Runstats Utility
- Reorg Utility
Unit 6 - Commands and program preparation
- Db2 Command Structure
- Display Command
- Archiving Logs
- Stop and Start Commands
- Executing Commands
- Program Preparation
Unit 7 - The Db2 system
- System Parameters (zParms)
- Address Spaces
- System Databases
- Buffer Pools
- Logging
- Integrity
- Security
Unit 8 - Db2 Shutdown, startup, and recovery
- Start and Stop Commands
- Db2 Shutdown Process
- Db2 Startup Phases
- System Recovery
- Object Recovery
- Copy Utility
- Recover Utility
Appendix A - Demonstration solutions