Db2 12 for z/OS Introduction to System Administration

Description

At Sixe Engineering we have been providing official IBM training around the world for over 12 years. Get the best training from our specialists in Europe. We have important discounts and offers for two or more students.

Course details

Target audience

This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z/OS.

Desired Prerequisites:

• 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 Administrator

Instructors

The great majority of the IBM courses we offer are taught directly by our engineers. This is the only way we can guarantee the highest quality. We complement all the training with our own materials and laboratories, based on our experience during the deployments, migrations and courses that we have carried out during all these years.

Added value

Our courses are deeply role oriented. To give an example, the needs for technology mastery are different for developer teams and for the people in charge of deploying and managing the underlying infrastructure. The level of previous experience is also important and we take it very seriously. That is why beyond (boring) commands and tasks, we focus on solving the problems that arise in the day to day of each team. Providing them with the knowledge, competencies and skills required for each project. In addition, our documentation is based on the latest version of each product.

Agenda and course syllabus

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

Do you need to adapt this syllabus to your needs? Are you interested in other courses?  Ask us without obligation.

Locations for on-site delivery

• Austria: Vienna
• Belgium: Brussels, Ghent
• Denmark: Cophenhagen
• Estonia: Tallinn
• Finland: Helsinki
• France: Paris, Marseille, Lyon
• Germany: Berlin, Munich, Cologne, Hamburg
• Greece: Athens, Thessaloniki
• Italy: Rome
• Louxemburg: Louxembourg (city)
• Netherlands: Amsterdam
• Norway: Oslo
• Portugal: Lisbon, Braga, Porto, Coimbra
• Slovakia: Bratislava
• Slovenia: Bratislava
• Spain: Madrid, Sevilla, Valencia, Barcelona, Bilbao, Málaga
• Sweden: Stockholm
• Turkey: Ankara
• United Kingdom: London