Db2 12 for z/OS Introduction to System Administration Course Overview

Course Prerequisites

• Basic Computer Knowledge.

Target Audience for Db2 12 for z/OS Introduction to System Administration

The Db2 12 for z/OS Introduction to System Administration course is designed for professionals managing IBM's mainframe database systems.

• Database Administrators (DBAs)
• System Administrators
• Mainframe System Engineers
• z/OS System Programmers
• IT Specialists working with IBM mainframe environments
• Data Architects
• Security Administrators
• Application Developers
• Support Engineers
• Technical Architects
• Operations Personnel responsible for Db2 for z/OS
• IMS Specialists (for those taking the IMS-related optional modules)
• CICS Technical Support and System Programmers (for those taking the CICS-related optional modules)
• IT Managers overseeing mainframe data environments
• Disaster Recovery Specialists
• Middleware Administrators working with Db2 databases
• Professionals looking to upskill for career advancement in mainframe database administration

Learning Objectives - What you will Learn in this Db2 12 for z/OS Introduction to System Administration?

Introduction to Course Learning Outcomes:

The Db2 12 for z/OS Introduction to System Administration course provides comprehensive insights into the management of Db2 environments, equipping participants with the necessary skills for effective system administration, security, and recovery.

Learning Objectives and Outcomes:

• Understand the process of starting and stopping Db2 within the z/OS environment, including the necessary commands and data set allocations.
• Gain knowledge of Db2 components and processes, including BSDS, logging, catalog and directory, program execution, and data sharing.
• Learn system security measures, including how to protect Db2 data sets and control connections, along with implementing Db2 authorization exits.
• Master Db2 authorization concepts, controlling access to both dynamic and static SQL, and managing distributed security.
• Comprehend program flow across various environments and understand the specifics of connection types and language interfaces.
• Acquire skills to work with TSO and batch environments for Db2 interaction and operations.
• (Optional) Delve into the transaction flow within IMS and CICS environments, including aspects like thread reuse and SIGNON exit.
• Explore the distributed Db2 environment, focusing on distributed attachment, location aliases, and the implementation of Db2 REST services.
• Understand the intricacies of Db2 logging, including log commands, archiving, and the Boot Strap Data Set (BSDS).
• Learn to utilize Db2 utilities for database maintenance, such as BACKUP and RESTORE SYSTEM, and understand their categorization.
• Develop the ability to monitor and control Db2 operations using Db2 commands, workload controls, and utility monitoring.
• Plan and execute recovery strategies, including table space recovery and managing log files for recovery processes.
• Prepare for system recovery and restart after both normal shutdown and system failure, understanding system checkpoints, and two-phase commit processing.
• (Optional) Familiarize with Java integration with Db2, including Java programming within the Db2 environment.
• (Optional) Understand the administrative task scheduler in Db2, including routine management and scheduling features.