CV845G: DB2 13 for z/OS Basic Database Administration
Inhalte
Preface
Unit 1 - Db2 Relational database concepts
Unit 2 - SQL and SPUFI
Unit 3 - Db2 objects (Storage groups, databases, and table spaces)
[1]Object concepts
[1]Storage Groups
[1]Databases
[1]Table Spaces
Unit 4 - Db2 Objects
[1]Tables
[1]Indexes
[1]Views
Unit 5 - Utilities
Unit 6 - Commands and program preparation
Unit 7 - The Db2 system
Unit 8 - Db2 Shutdown, startup, and recovery
- 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)
[1]Object concepts
[1]Storage Groups
[1]Databases
[1]Table Spaces
Unit 4 - Db2 Objects
[1]Tables
[1]Indexes
[1]Views
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
Ziele
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
Unterlagen
Original IBM Herstellerunterlage
Preise
Kursgebühr
2.550,00 € exkl. MwSt.
3.034,50 € inkl. MwSt. Kursdauer 3 Tage
Ihr CBT Trainingsteam
Gabriela Bücherl
Geschäftsführung
Vertrieb
Kontakt/Fragen:
beratung@cbt-training.de
Telefon: +49 (0)89-4576918-16
Anfrage für ein Firmenseminar
- Individuelle Zusammenstellung der Themen
- Maßgeschneidert auf Ihre Ziele
- Inhouse oder als Virtual Classroom LIVE Training
Leistungen Präsenz
- Schulung im Trainingscenter
- Verpflegung
- Teilnahmebestätigung / Zertifikat
Leistungen bei VCL Training
- Technischer Support
- Online Zugang
- Teilnahmebestätigung / Zertifikat