Db2 12 for z/OS Introduction to System AdministrationCV853GIBIBMIB-CV853G1<ul>
<li>Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem</li><li>Basic knowledge of SQL</li><li>At least one year as a z/OS systems programmer or equivalent knowledge</li></ul><p>OR</p>
<ul>
<li>At least one year as a Db2 for z/OS Database Administrator</li></ul><p>This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z/OS.</p><p>Starting, stopping, and accessing Db2
</p>
<ul>
<li>• Starting Db2 as part of the z/OS IPL process</li><li>• Data set allocation and APF authorization</li><li>• The START DB2 and STOP DB2 commands</li><li>• zParms, DSNTIJUZ, and DSNZPARM</li><li>• Address spaces</li><li>• IRLM and lock storage</li></ul><p>
Db2 components and processes
</p>
<ul>
<li>• BSDS and logging</li><li>• Catalog and directory</li><li>• Program preparation and execution</li><li>• Transaction execution</li><li>• Data sharing in the sysplex</li></ul><p>
System security
</p>
<ul>
<li>• Protecting Db2 data sets</li><li>• Controlling connections to Db2</li><li>• Db2 authorization exits</li><li>• Trusted context and roles</li><li>• Securing an application server</li></ul><p>
Db2 authorization
</p>
<ul>
<li>• Authorizations</li><li>• Controlling access for dynamic and static SQL</li><li>• Access control authorization exits</li><li>• Distributed security</li></ul><p>Program flow for all environments
</p>
<ul>
<li>• Connection types and language interfaces</li><li>• Program flow</li></ul><p>
TSO and batch environments
</p>
<ul>
<li>• TSO</li><li>• Utilities</li></ul><p>
Transaction flow in IMS and CICS (optional)
</p>
<ul>
<li>• Transaction processing</li><li>• Thread reuse</li><li>• SIGNON exit</li></ul><p>
CICS - Db2 environment (optional)
</p>
<ul>
<li>• CICS connections to Db2</li><li>• DSNC transaction</li></ul><p>
IMS - Db2 environment (optional)
</p>
<ul>
<li>• IMS-Db2 introduction</li><li>• IMS TM</li><li>• IMS/DLI batch environment</li></ul><p>
Distributed - Db2 environment
</p>
<ul>
<li>• Distributed attachment</li><li>• Location aliases</li><li>• DDF profiling</li><li>• Block fetch</li><li>• Db2 REST services</li></ul><p>
Logging
</p>
<ul>
<li>• The Db2 log</li><li>• Log commands</li><li>• Archiving considerations</li><li>• BSDS</li></ul><p>
Db2 utilities
</p>
<ul>
<li>• Categorization</li><li>• DSNJU003 and DSNJU004</li><li>• BACKUP and RESTORE SYSTEM</li></ul><p>
Operations (monitoring and controlling Db2)
</p>
<ul>
<li>• Issuing Db2 commands</li><li>• Basic workload controls</li><li>• Monitoring and controlling utilities</li><li>• DISPLAY commands</li><li>• Starting / stopping databases</li></ul><p>
Recovery
</p>
<ul>
<li>• Planning for recovery</li><li>• Table space recovery</li><li>• Log considerations</li><li>• DISPLAY and SET LOG commands</li><li>• Recovery considerations</li></ul><p>
System recover/restart
</p>
<ul>
<li>• System checkpoints</li><li>• System restart after normal shutdown</li><li>• Page externalization</li><li>• Two-phase commit processing</li><li>• System restart after system failure</li><li>• Recovery considerations</li></ul><p>
Java with Db2 (optional)
</p>
<ul>
<li>• Java</li></ul><p>
Administrative task scheduler (optional)
</p>
<ul>
<li>• Overview</li><li>• Routines</li><li>• Scheduling features</li><li>• Life cycle</li><li>• Syncronization</li><li>• Commands</li></ul><p>Starting, stopping, and accessing Db2
</p>
<ul>
<li>• Starting Db2 as part of the z/OS IPL process</li><li>• Data set allocation and APF authorization</li><li>• The START DB2 and STOP DB2 commands</li><li>• zParms, DSNTIJUZ, and DSNZPARM</li><li>• Address spaces</li><li>• IRLM and lock storage</li></ul><p>
Db2 components and processes
</p>
<ul>
<li>• BSDS and logging</li><li>• Catalog and directory</li><li>• Program preparation and execution</li><li>• Transaction execution</li><li>• Data sharing in the sysplex</li></ul><p>
System security
</p>
<ul>
<li>• Protecting Db2 data sets</li><li>• Controlling connections to Db2</li><li>• Db2 authorization exits</li><li>• Trusted context and roles</li><li>• Securing an application server</li></ul><p>
Db2 authorization
</p>
<ul>
<li>• Authorizations</li><li>• Controlling access for dynamic and static SQL</li><li>• Access control authorization exits</li><li>• Distributed security</li></ul><p>Program flow for all environments
</p>
<ul>
<li>• Connection types and language interfaces</li><li>• Program flow</li></ul><p>
TSO and batch environments
</p>
<ul>
<li>• TSO</li><li>• Utilities</li></ul><p>
Transaction flow in IMS and CICS (optional)
</p>
<ul>
<li>• Transaction processing</li><li>• Thread reuse</li><li>• SIGNON exit</li></ul><p>
CICS - Db2 environment (optional)
</p>
<ul>
<li>• CICS connections to Db2</li><li>• DSNC transaction</li></ul><p>
IMS - Db2 environment (optional)
</p>
<ul>
<li>• IMS-Db2 introduction</li><li>• IMS TM</li><li>• IMS/DLI batch environment</li></ul><p>
Distributed - Db2 environment
</p>
<ul>
<li>• Distributed attachment</li><li>• Location aliases</li><li>• DDF profiling</li><li>• Block fetch</li><li>• Db2 REST services</li></ul><p>
Logging
</p>
<ul>
<li>• The Db2 log</li><li>• Log commands</li><li>• Archiving considerations</li><li>• BSDS</li></ul><p>
Db2 utilities
</p>
<ul>
<li>• Categorization</li><li>• DSNJU003 and DSNJU004</li><li>• BACKUP and RESTORE SYSTEM</li></ul><p>
Operations (monitoring and controlling Db2)
</p>
<ul>
<li>• Issuing Db2 commands</li><li>• Basic workload controls</li><li>• Monitoring and controlling utilities</li><li>• DISPLAY commands</li><li>• Starting / stopping databases</li></ul><p>
Recovery
</p>
<ul>
<li>• Planning for recovery</li><li>• Table space recovery</li><li>• Log considerations</li><li>• DISPLAY and SET LOG commands</li><li>• Recovery considerations</li></ul><p>
System recover/restart
</p>
<ul>
<li>• System checkpoints</li><li>• System restart after normal shutdown</li><li>• Page externalization</li><li>• Two-phase commit processing</li><li>• System restart after system failure</li><li>• Recovery considerations</li></ul><p>
Java with Db2 (optional)
</p>
<ul>
<li>• Java</li></ul><p>
Administrative task scheduler (optional)
</p>
<ul>
<li>• Overview</li><li>• Routines</li><li>• Scheduling features</li><li>• Life cycle</li><li>• Syncronization</li><li>• Commands</li></ul>- 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 AdministratorThis 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 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
- • CommandsStarting, 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
- • Commands3 jours2400.002100.002250.002100.00