Résumé du cours
This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.
Moyens d'évaluation :
- Quiz pré-formation de vérification des connaissances (si applicable)
- Évaluations formatives pendant la formation, à travers les travaux pratiques réalisés sur les labs à l’issue de chaque module, QCM, mises en situation…
- Complétion par chaque participant d’un questionnaire et/ou questionnaire de positionnement en amont et à l’issue de la formation pour validation de l’acquisition des compétences
A qui s'adresse cette formation
This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z/OS.
Pré-requis
- 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
Contenu
Starting, stopping, and accessing Db2
- • Starting Db2 as part of the z/OS IPL process
- • Data set allocation and APF authorization
- • The START DB2 and STOP DB2 commands
- • zParms, DSNTIJUZ, and DSNZPARM
- • Address spaces
- • IRLM and lock storage
Db2 components and processes
- • BSDS and logging
- • Catalog and directory
- • Program preparation and execution
- • Transaction execution
- • Data sharing in the sysplex
System security
- • Protecting Db2 data sets
- • Controlling connections to Db2
- • Db2 authorization exits
- • Trusted context and roles
- • Securing an application server
Db2 authorization
- • Authorizations
- • Controlling access for dynamic and static SQL
- • Access control authorization exits
- • Distributed security
Program flow for all environments
- • Connection types and language interfaces
- • Program flow
TSO and batch environments
- • TSO
- • Utilities
Transaction flow in IMS and CICS (optional)
- • Transaction processing
- • Thread reuse
- • SIGNON exit
CICS - Db2 environment (optional)
- • CICS connections to Db2
- • DSNC transaction
IMS - Db2 environment (optional)
- • IMS-Db2 introduction
- • IMS TM
- • IMS/DLI batch environment
Distributed - Db2 environment
- • Distributed attachment
- • Location aliases
- • DDF profiling
- • Block fetch
- • Db2 REST services
Logging
- • The Db2 log
- • Log commands
- • Archiving considerations
- • BSDS
Db2 utilities
- • Categorization
- • DSNJU003 and DSNJU004
- • BACKUP and RESTORE SYSTEM
Operations (monitoring and controlling Db2)
- • Issuing Db2 commands
- • Basic workload controls
- • Monitoring and controlling utilities
- • DISPLAY commands
- • Starting / stopping databases
Recovery
- • Planning for recovery
- • Table space recovery
- • Log considerations
- • DISPLAY and SET LOG commands
- • Recovery considerations
System recover/restart
- • System checkpoints
- • System restart after normal shutdown
- • Page externalization
- • Two-phase commit processing
- • System restart after system failure
- • Recovery considerations
Java with Db2 (optional)
- • Java
Administrative task scheduler (optional)
- • Overview
- • Routines
- • Scheduling features
- • Life cycle
- • Syncronization
- • Commands
Moyens Pédagogiques :