Signed in as:
filler@godaddy.com
Db2 for z/OS: System & Data Recovery [DSDR]
OVERVIEW
This course provides a thorough and comprehensive introduction into recovery and restart procedures for both the Db2 for z/OS system and its data. The course describes and explains in detail the components, utilities and procedures involved in data and system backup and recovery, together with the various methods of utilizing them to ensure maximum availability. This course is applicable to all Db2 for z/OS environments.
COURSE DURATION & PRICE
4 Days
Hands-On
$2,850
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- Db2 Overview
- Db2 Logging
- Introduction to Db2 Utilities
- Utilities for Data Backup & Recovery
- Other Db2 Utilities
- Other Online Utilities
- Stand-Alone Utilities (service aids)
- Catalog & Directory Recovery
- Db2 System and Operations
- Abnormal Termination and Restart
- DB2 Physical Data Storage
- Problem Analysis & Resolution
COURSE OBJECTIVES
- List all the major system, backup and recovery components
- Describe the need for Db2 logging to assist in recovery situations &
- Describe the need for and use of all Db2 utilities
- Use the Db2 utilities and service aids specific to problem determination and recovery situations
- Identify when service aids may be required for use in recovery situations
- Describe the additional considerations when backing up and recovering catalog and directory tablespaces
- Describe the actions taken during normal start-up, operation, and shutdown of the Db2 system
- Describe the additional actions necessary following an abnormal termination of the Db2 system
- Explain why and how a deferred restart may be performed and understand the effect it will have on the Db2 system and data
- Explain why and how a conditional restart may be performed and the effect it will have on the Db2 system and data
- Understand the options available for a conditional restart and when each may be required
- Analyze any outstanding work following a deferred or conditional restart, and take the actions required to complete it
- Describe the structure and format of Db2 pagesets
- Analyze and repair broken Db2 pages
- Interpret common error messages, and decide upon the actions required
- Understand and implement Db2 system and data recovery and restart procedures
PREREQUISITES
A good knowledge of TSO/ISPF, SQL and general Db2 principles, structure and components
Email at Info@zcubedtech.com to find out more
Db2 for z/OS: Db2 Introduction to Data Sharing [DBDS]
OVERVIEW
This course introduces the concepts, components and considerations involved when using Db2 for z/OS data sharing. It explains the reasons for using data sharing, and explores the implementation considerations such as Coupling Facility structures, data integrity and the operational and performance issues that need to be addressed when considering Db2 data sharing.
COURSE DURATION & PRICE
1 Day
Hands-On
$895
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- Data Sharing Overview
- Data Integrity & Consistency
- Implementing Data Sharing
- Operational Considerations
COURSE OBJECTIVES
On successful completion of this course attendees will be able to:
- Describe the concepts of Db2 data sharing and its uses
- Describe the need for the Coupling Facility structures used by DB2 data sharing
- Explain how Db2 uses the Coupling Facility structures: Group buffer pools, Global locking structure & Shared Communication Area (SCA)
- Understand how data sharing is implemented and controlled
- Identify monitoring and performance issues for a Db2 data-sharing environment
PREREQUISITES
Attendees will need a good understanding of Db2. A basic understanding of parallel sysplex and the Coupling Facility would be beneficial; this can be obtained by attending course Parallel Sysplex Concepts & Facilities [PSX1].
Email at Info@zcubedtech.com to find out more
Db2 for z/OS:Db2 Exploiting Temporal Tables [DBTT]
OVERVIEW
Many IT systems require historical data to be kept, in addition to the current status information. Db2 V10 for z/OS introduced temporal data support to provide this functionality, whereby the historical data is automatically maintained. This intensive course provides an in-depth look at how temporal tables may be created and exploited.
COURSE DURATION & PRICE
1 Day
Hands-On
$895
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- Introduction to Temporal Tables
- Defining System-Period Temporal Tables
- Defining Application-Period Temporal Tables
- SQL Extensions for Temporal Tables
- Archive Tables
- Db2 Utility Options for Temporal Tables
- Practical Exercises - Defining temporal tables; manipulating & reporting data in temporal tables
COURSE OBJECTIVES
- Identify applications that may benefit from using temporal tables
- Describe how temporal tables may be used to automatically handle historical data by using data versioning
- Explain the difference between system-period and application-period data versioning
- Define and use system and application-period temporal tables
- Describe and use the new period-specification clauses in the SQL language
- Use new utility options specific to temporal tables
- Describe and use archive tables'
PREREQUISITES
A good understanding of Db2 and experience of using SQL
Email at Info@zcubedtech.com to find out more
Db2 z/OS Using Stored Procedures [DBSP]
OVERVIEW
This one-day course is a comprehensive introduction and explanation of the use of Stored Procedures in a Db2 for z/OS environment.
COURSE DURATION & PRICE
1 Day
Hands-On
$895
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- Introduction to Stored Procedures
- Stored Procedure Environment
- Writing and Preparing External Stored Procedures
- Writing and Preparing SQL Procedures
- Defining Stored Procedures to Db2
- Writing and Preparing the Calling Application
COURSE OBJECTIVES
- Describe Db2 Stored Procedures at a conceptual and practical level
- Write and prepare Db2 Stored Procedures
- Use Db2 Stored Procedures
PREREQUISITES
A working knowledge of Db2 is essential
Email at Info@zcubedtech.com to find out more
Copyright © 2025 ZCubed Technologies - All Rights Reserved.