IBM DB2 für z/OS - IBM CV021G - Introduction to DB2 for z/OS for Systems and Operations Personnel

IBM CV021G - Introduction to DB2 for z/OS for Systems and Operations Personnel

Kurssprache: Deutsch, Schulungsunterlagen: Englisch.
IBM-Kursnr.: CV021G
This course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.
DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of: DB2 Objects / Structured Query Language / DB2 Commands / DB2 Utilities / DB2 Logging / DB2 Program Preparation. The course materials cover DB2 11 for z/OS.
Hinweis: Dieses Seminar wird in Zusammenarbeit mit dem offiziellen Partner des IBM Global Training Providers Global Knowledge: Integrata AG oder dem IBM Education Delivery und IBM Sales Partner von Arrow ECS: Fast Lane Institute for Knowledge Transfer GmbH durchgeführt.

Inhalt

Day 1
(00:15) Welcome
(00:30) Unit 1: z/OS Prerequisite Review
(00:10) Exercise 1: Connecting to z/OS and Creating Data Sets
(00:05) Exercise 1 Review
(01:15) Unit 2: DB2 Relational Database Concepts
(01:15) Unit 3: Structured Query Language (SQL) and SPUFI
(00:45) Exercise 2: SQL and SPUFI
(00:15) Exercise 2 Review
(01:30) Unit 4: DB2 Objects (Databases and Table Spaces)
(00:45) Exercise 3: Databases and Table Spaces
(00:15) Exercise 3 Review
(01:30) Unit 4: DB2 Objects (Tables, Indexes, and Views)
Day 2
(00:45) Exercise 4: Tables, Indexes, and Views
(00:15) Exercise 4 Review
(01:00) Unit 4: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
(00:30) Exercise 5: Qualified Names, Implicit Object Creation, and SQL Statements
(00:15) Exercise 5 Review
(01:30) Unit 5: The DB2 System
(00:45) Exercise 6: The DB2 System
(00:15) Exercise 6 Review
(02:00) Unit 6: DB2 Commands and Program Preparation
Day 3
(00:45) Exercise 7: DB2 Commands
(00:15) Exercise 7 Review
(02:00) Unit 7: DB2 Utilities
(01:00) Exercise 8: DB2 Utilities
(00:15) Exercise 8 Review
(01:15) Unit 8: DB2 Shutdown, Startup, and Recovery
(00:45) Exercise 9: DB2 Recovery
(00:15) Exercise 9 Review
(00:30) Unit 9: Course Summary

Voraussetzungen

You should have a working knowledge of z/OS, TSO, ISPF, and SDSF / sequential, partitioned, and VSAM data sets and basic JCL.

Zielgruppe

This course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

Zielsetzung

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of: DB2 Objects / Structured Query Language / DB2 Commands / DB2 Utilities / DB2 Logging / DB2 Program Preparation. The course materials cover DB2 11 for z/OS.