> > CV853G Detailed outline

Db2 12 for z/OS Introduction to System Administration (CV853G)

Course Description Schedule Course Outline

Detailed Course Outline

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

 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!