- Cours pratique
- IBM
- Informatique
- Officiel
Formation DB2 13 for z/OS : Introduction to System Administration
- Durée
- 3 jours
- Niveau
- Intermédiaire
- Modalités
- Distanciel
Description de la formation DB2 13 System Administration
This course introduces the skills and knowledge required to administer a Db2 13 for z/OS system. Utilizing the lecture and a z/OS lab environment, learners will gain practical practice starting, stopping, and accessing Db2; examining the zParms and data sets; connecting to a Db2 subsystem via Data Studio; querying the catalog; exploring RACF; examining threads; working with DB2I; modifying Db2 active and archived logs; utilizing online utilities; monitoring and controlling Db2; recovering the catalog and directory; and using the administrative task scheduler.
Objectifs pédagogiques
Cette formation DB2 13 System Administration vous donne les connaissances et compétences pour :
- 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
Objectifs opérationnels
Savoir administrer un système DB2 13 pour z/OS.
Programme
Contenu du cours, module par module
17 modules
- 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
- BSDS and logging
- Catalog and directory
- Program preparation and execution
- Transaction execution
- Data sharing in the sysplex
- Protecting Db2 data sets
- Controlling connections to Db2
- Db2 authorization exits
- Trusted context and roles
- Securing an application server
- Authorizations
- Controlling access for dynamic and static SQL
- Access control authorization exits
- Distributed security
- Connection types and language interfaces
- Program flow
- TSO
- Utilities
- Transaction processing
- Thread reuse
- SIGNON exit
- CICS connections to Db2
- DSNC transaction
- IMS-Db2 introduction
- IMS TM
- IMS/DLI batch environment
- Distributed attachment
- Location aliases
- DDF profiling
- Block fetch
- Db2 REST services
- The Db2 log
- Log commands
- Archiving considerations
- BSDS
- Categorization
- DSNJU003 and DSNJU004
- BACKUP and RESTORE SYSTEM
- Issuing Db2 commands
- Basic workload controls
- Monitoring and controlling utilities
- DISPLAY commands
- Starting / stopping databases
- Planning for recovery
- Table space recovery
- Log considerations
- DISPLAY and SET LOG commands
- Recovery considerations
- System checkpoints
- System restart after normal shutdown
- Page externalization
- Two-phase commit processing
- System restart after system failure
- Recovery considerations
- Java
- Overview
- Routines
- Scheduling features
- Life cycle
- Syncronization
- Commands
Programme mis à jour le 19/11/2025
Public concerné
This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 13 for z/OS.
Prérequis
Participants should have the following skills :
- 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
J’évalue mes connaissances pour vérifier que je dispose des prérequis nécessaires pour profiter pleinement de cette formation en faisant le test de prérequis.
Faire le testFinancement
Cette formation peut être prise en charge par votre entreprise, seule ou avec l’appui de son opérateur de compétences. Nous fournissons le devis et les pièces attendues par l’OPCO.
Formations liées
- DB2 13 pour z/OS : Advanced Database AdministrationRéf. CV881G2 joursAvancé1 700 €
- DB2 13 pour z/OS : Database AdministrationRéf. CV845G3 joursIntermédiaireProchaine session : 3 nov.2 550 €
- Informix Administration - Niveau 1Réf. INAD15 joursIntermédiaire
- Informix Administration - Niveau 2 : Tuning et RéplicationsRéf. INAD23 joursAvancé