When does class start/end?
Classes begin promptly at 9:00 am, and typically end at 5:00 pm.
This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system. Skills Gained After completing this course, students should be able to:...Read More
This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.
After completing this course, students should be able to:
This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z/OS.
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 storageDb2 components and processes- BSDS and logging- Catalog and directory- Program preparation and execution- Transaction execution- Data sharing in the sysplexSystem security- Protecting Db2 data sets- Controlling connections to Db2- Db2 authorization exits- Trusted context and roles- Securing an application serverDb2 authorization- Authorizations- Controlling access for dynamic and static SQL- Access control authorization exits- Distributed securityProgram flow for all environments- Connection types and language interfaces- Program flowTSO and batch environments- TSO- UtilitiesTransaction flow in IMS and CICS (optional)- Transaction processing- Thread reuse- SIGNON exitCICS - Db2 environment (optional)- CICS connections to Db2- DSNC transactionIMS - Db2 environment (optional)- IMS-Db2 introduction- IMS TM- IMS/DLI batch environmentDistributed - Db2 environment- Distributed attachment- Location aliases- DDF profiling- Block fetch- Db2 REST servicesLogging- The Db2 log- Log commands- Archiving considerations- BSDSDb2 utilities- Categorization- DSNJU003 and DSNJU004- BACKUP and RESTORE SYSTEMOperations (monitoring and controlling Db2)- Issuing Db2 commands- Basic workload controls- Monitoring and controlling utilities- DISPLAY commands- Starting / stopping databasesRecovery- Planning for recovery- Table space recovery- Log considerations- DISPLAY and SET LOG commands- Recovery considerationsSystem recover/restart- System checkpoints- System restart after normal shutdown- Page externalization- Two-phase commit processing- System restart after system failure- Recovery considerationsJava with Db2 (optional)- JavaAdministrative task scheduler (optional)- Overview- Routines- Scheduling features- Life cycle- Syncronization- Commands