Kurs-ID: IBM_CV853G
Db2 12 for z/OS Introduction to System Administration (CV853G)

This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.
Alle IBM Trainings werden mit Original IBM Schulungsunterlagen angeboten und finden in Kooperation mit dem von Arrow ECS autorisierten IBM Schulungspartner esciris statt.
Termin buchenSeminarinhalte
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
Zielgruppe
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
- 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 knowledgeOR
- At least one year as a Db2 for z/OS Database Administrator
Dauer und Zeiten
3 Kurstage
Termine
Kurspreis für offene Schulungen
2400,00 € zzgl. 19% MwSt. (2856,00 € inkl. 19% MwSt.)
Hinweis
Das Training findet auf Deutsch statt.