Db2 12 for z/OS Basic Database Administration

Details
Kursnummer:
CV844G
Anbieter:
IBM
Kursdauer:
3 Tage
Sprache:
Deutsch
Unterlagen:
Englisch
Startdatum:
30. Mai 2022
Enddatum:
01. Jun 2022
Preis und Durchführung
Ort:
Virtual Classroom
Preis p. Teiln.:
2.100,00 € zzgl. MwSt

Badge

Überblick

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Zielgruppe

  • 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.

Voraussetzungen

  • 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

Kursziele

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

Kursthemen

Please refer to course overview