LENGTH: 24 Hours (3 days)
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
Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.
GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process:
Once you enroll in a GTP class, you will receive a confirmation letter that should show: