Schulung - IBM CV844G - Db2 12 for z/OS Basic Database Administration

  • Live Online oder Präsenz
Download als PDF
DURCHFÜHRUNG MIT TERMIN
Nr.
30351

Dauer
24h00

Preis
2.400,00 € netto
2.856,00 € inkl. 19% MwSt.

TERMIN UND ORT NACH ABSPRACHE
On-demand Training
Sind Sie an diesem Thema interessiert?
Unsere Experten entwickeln Ihr individuell angepasstes Seminar!

Teilen Sie dieses Seminar

Overview

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.

Lesen Sie mehr
Zielgruppe

Wer sollte teilnehmen:

Zielgruppe

Audience

  • 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

Prerequisites

  • 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

Trainingsprogramm

Trainingsprogramm

Course Outline

PrefaceCourse OverviewIntended AudienceCourse ObjectivesPrerequisitesUnit 1 - Db2 Relational database conceptsRelational Database designData accessInteracting with Db2Catalog and directoryUnit 2 - SQL and SPUFISQL SELECT statement reviewSQL INSERT, UPDATE, DELETE reviewSQL COMMIT and ROLLBACK reviewJoining tablesExecuting SQL using SPUFIUnit 3 - Db2 objects (Storage groups, databases, and table spaces)Object conceptsStorage GroupsDatabasesTable SpacesUnit 4 - Db2 Objects (Tables, indexes, and views)Tables o AliasesTable constraints o Primary key o Foreign key o Check o Referential integrityIndexesViewsQualified namesImplicit object creationUnit 5 - UtilitiesUtility CategoriesLoad UtilityCheck Data UtilityUnload UtilityRunstats UtilityReorg UtilityUnit 6 - Commands and program preparationDb2 Command StructureDisplay CommandArchiving LogsStop and Start CommandsExecuting CommandsProgram PreparationUnit 7 - The Db2 systemSystem Parameters (zParms)Address SpacesSystem DatabasesBuffer PoolsLoggingIntegritySecurityUnit 8 - Db2 Shutdown, startup, and recoveryStart and Stop CommandsDb2 Shutdown ProcessDb2 Startup PhasesSystem RecoveryObject RecoveryCopy UtilityRecover UtilityAppendix A - Demonstration solutions

Objective

Please refer to course overview

Schulungsmethode

Schulungsmethode

presentation, discussion, hands-on exercises

Weitere Informationen

Weitere Informationen

Termine und Orte

Sortieren nach:

  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
  • 2.400,00 € Netto
    Noch freie Plätze
    Jetzt buchen
    Live Online Training
    Live Online Training
Schulung - IBM CV844G - Db2 12 for z/OS Basic Database Administration