DB2 13 pour z/OS : Database Administration
- Durée
- Durée :3 jours
- Niveau
- Niveau :Intermédiaire
- Certification
- Certification :Non
2550€ HT
Prochaine session :
DB2 13 for z/OS : Introduction to System Administration
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.
Programme de la formation
Objectif opérationnel :
Savoir administrer un système DB2 13 pour z/OS.
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
Starting, stopping, and accessing Db2
Starting Db2 as part of the z/OS IPL processData 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 loggingCatalog and directory
Program preparation and execution
Transaction execution
Data sharing in the sysplex
System security
Protecting Db2 data setsControlling connections to Db2
Db2 authorization exits
Trusted context and roles
Securing an application server
Db2 authorization
AuthorizationsControlling access for dynamic and static SQL
Access control authorization exits
Distributed security
Program flow for all environments
Connection types and language interfacesProgram flow
TSO and batch environments
TSOUtilities
Transaction flow in IMS and CICS (optional)
Transaction processingThread reuse
SIGNON exit
CICS - Db2 environment (optional)
CICS connections to Db2DSNC transaction
IMS - Db2 environment (optional)
IMS-Db2 introductionIMS TM
IMS/DLI batch environment
Distributed - Db2 environment
Distributed attachmentLocation aliases
DDF profiling
Block fetch
Db2 REST services
Logging
The Db2 logLog commands
Archiving considerations
BSDS
Db2 utilities
CategorizationDSNJU003 and DSNJU004
BACKUP and RESTORE SYSTEM
Operations (monitoring and controlling Db2)
Issuing Db2 commandsBasic workload controls
Monitoring and controlling utilities
DISPLAY commands
Starting / stopping databases
Recovery
Planning for recoveryTable space recovery
Log considerations
DISPLAY and SET LOG commands
Recovery considerations
System recover/restart
System checkpointsSystem restart after normal shutdown
Page externalization
Two-phase commit processing
System restart after system failure
Recovery considerations
Java with Db2 (optional)
JavaAdministrative task scheduler (optional)
OverviewRoutines
Scheduling features
Life cycle
Syncronization
Commands
Public cible :
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.
Date de mise à jour du programme : 19/11/2025