Wir beraten Sie gerne!
+49 40 253346-10     Kontakt
> > > CV844G Detaillierte Beschreibung

Db2 12 for z/OS Basic Database Administration (CV844G)

Detaillierter Kursinhalt

Preface • Course Overview • Intended Audience • Course Objectives • Prerequisites

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  o Aliases • Table constraints  o Primary key  o Foreign key  o Check  o 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

 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.