Schulung - IBM CV853G - Db2 12 for z/OS Introduction to System Administration

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

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 provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.

Lesen Sie mehr
Zielgruppe

Wer sollte teilnehmen:

Zielgruppe

Audience

This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z/OS.

Voraussetzungen

Prerequisites

  • Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem
  • Basic knowledge of SQL
  • At least one year as a z/OS systems programmer or equivalent knowledge

OR

  • At least one year as a Db2 for z/OS Database Administrator

Trainingsprogramm

Trainingsprogramm

Course Outline

Starting, stopping, and accessing Db2Starting Db2 as part of the z/OS IPL processData set allocation and APF authorizationThe START DB2 and STOP DB2 commandszParms, DSNTIJUZ, and DSNZPARMAddress spacesIRLM and lock storageDb2 components and processesBSDS and loggingCatalog and directoryProgram preparation and executionTransaction executionData sharing in the sysplexSystem securityProtecting Db2 data setsControlling connections to Db2Db2 authorization exitsTrusted context and rolesSecuring an application serverDb2 authorizationAuthorizationsControlling access for dynamic and static SQLAccess control authorization exitsDistributed securityProgram flow for all environmentsConnection types and language interfacesProgram flowTSO and batch environmentsTSOUtilitiesTransaction flow in IMS and CICS (optional)Transaction processingThread reuseSIGNON exitCICS - Db2 environment (optional)CICS connections to Db2DSNC transactionIMS - Db2 environment (optional)IMS-Db2 introductionIMS TMIMS/DLI batch environmentDistributed - Db2 environmentDistributed attachmentLocation aliasesDDF profilingBlock fetchDb2 REST servicesLoggingThe Db2 logLog commandsArchiving considerationsBSDSDb2 utilitiesCategorizationDSNJU003 and DSNJU004BACKUP and RESTORE SYSTEMOperations (monitoring and controlling Db2)Issuing Db2 commandsBasic workload controlsMonitoring and controlling utilitiesDISPLAY commandsStarting / stopping databasesRecoveryPlanning for recoveryTable space recoveryLog considerationsDISPLAY and SET LOG commandsRecovery considerationsSystem recover/restartSystem checkpointsSystem restart after normal shutdownPage externalizationTwo-phase commit processingSystem restart after system failureRecovery considerationsJava with Db2  (optional)JavaAdministrative task scheduler (optional)OverviewRoutinesScheduling featuresLife cycleSyncronizationCommands

Objective

After completing this course, students should be able to:

  • Start and stop a Db2 subsystem
  • Use the SET SYSPARM command
  • Access the system log to gather information about the subsystem initialization, operation, or shutdown
  • Describe the components and address space structure of a Db2 subsystem
  • Explain the use of RACF (or another external security program) for Db2 connection security
  • Explain the use of Roles and Trusted Contexts
  • Implement security procredures for a Db2 subsystem
  • Explain Db2 program flow for all environments
  • Explain parameter setting for the IRLM
  • Invoke and utilitze Db2 TSO facilities
  • Use the Db2 Catalog to monitor subsystem authorizations
  • Work with the Active Log data sets
  • Explain Db2 logging
  • Use SET LOG SUSPEND and SET LOG RESUME
  • Use DSNJU004 to print log map and interpret the results
  • Use DSNJU003 to rename Db2 data sets
  • Plan for recovery of a BSDS failure
  • Monitor and control a Db2 subsystem
  • Explain transaction flow in IMS and CICS environments (optional)
  • Describe the CICS and DB2 environment (optional)
  • Explain the difference between JDBC and SQLJ
  • And much more
     

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
Schulung - IBM CV853G - Db2 12 for z/OS Introduction to System Administration