Day 1
1. The DB2 Concepts and Terminology
2. Creating databases and tablespaces
Hands-on Workshop - Database / Trablespace
3. Creating Tables and other objects
Hands-on Workshop – Tables, Referential Integrity, Check Constraints, UDT, UDF
Day 2
4. Security and Locking
5. DB2 utilities I – LOAD, CHECK DATA, RUNSTATS
Hands-on Workshop – LOAD, CHECK DATA, RUNSTATS
6. DB2 utilities II – COPY, REORG, UNLOAD
Hands-on Workshop – COPY, REORG, UNLOAD
7. Tablespace Recovery - RECOVERY
Hands-on Workshop - Tablespace Recovery
Day 3
8. Programming and Performance
Hands-on Workshop – Programming and Performance
9. DB2 Version 8 changes
Appendices
Appendix A – IBM Sample Tables
Appendix B – Bibliography
Appendix C – The Programming Workshop
Appendix D – EXPLAIN PLAN Statement and PLAN_TABLE and DSN_STATEMNT_TABLE
Appendix E – Hints to Success
Appendix F – SQLCODES / SQLSTATES
Appendix G – QMF Overview
Appendix H – Stored Procedures
Appendix I - "Common" SQL Errors
Appendix J – Version 6 Functions Summary
Appendix K – UDT and UDF
Appendix L - Cast Testing
Appendix M - Trigger Introduction
Appendix N – DB2 for WINDOWs Overview
Appendix Z 6– Changes Summary - DB2 V
Appendix Z 7– Changes