Db2 12 for z/OS Basic Database Administration

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

• Students who will be performing the role of Db2 for z/OS database administrators who need to acquire the basic skills required to administer a Db2 database.

• Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF
• Familiarity with SQL data manipulation statements (SELECT, INSERT, UPDATE, and DELETE) to access and change the contents of Db2 tables

Please refer to course overview