SMLAN Software & Management Training Keep calm and study smart
esciris authorized training reseller

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

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.

Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.

Kurs-Id: IBM_CV844G

Seminarinhalt

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

Informationen
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.
Vorkenntnisse

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

3 Kurstage (pro Tag 8 Unterrichtsstunden à 45 Min.)

Termine
  • Düsseldorf (AE7F3): 21.01. - 23.01.19: AnmeldenDb2 12 for z/OS Basic Database Administration (CV844G)SMLan Software & Management TrainingKastanienallee 53Berlin10119This 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.Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.2499.00EUR
  • München (S9XQ3): 25.03. - 27.03.19: AnmeldenDb2 12 for z/OS Basic Database Administration (CV844G)SMLan Software & Management TrainingKastanienallee 53Berlin10119This 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.Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.2499.00EUR
  • Berlin (YP0C7): 20.05. - 22.05.19: AnmeldenDb2 12 for z/OS Basic Database Administration (CV844G)SMLan Software & Management TrainingKastanienallee 53Berlin10119This 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.Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.2499.00EUR
  • Stuttgart (S9116): 22.07. - 24.07.19: AnmeldenDb2 12 for z/OS Basic Database Administration (CV844G)SMLan Software & Management TrainingKastanienallee 53Berlin10119This 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.Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.2499.00EUR
  • Hamburg (K7O58): 16.09. - 18.09.19: AnmeldenDb2 12 for z/OS Basic Database Administration (CV844G)SMLan Software & Management TrainingKastanienallee 53Berlin10119This 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.Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.2499.00EUR
  • Frankfurt (N2XX2): 18.11. - 20.11.19: AnmeldenDb2 12 for z/OS Basic Database Administration (CV844G)SMLan Software & Management TrainingKastanienallee 53Berlin10119This 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.Alle IBM Trainings finden in Kooperation mit unserem Partner esciris GmbH statt.2499.00EUR
Hinweis

Das Training findet auf Deutsch statt.

Kurspreis für offene Schulungen

2100,00 € zzgl. 19% MwSt. (2499,00 € inkl. 19% MwSt.)