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