Order your ZCubed Technologies CICS WallChart Today

973.299.9669

  • Home
  • Education
    • CICS
    • MQSeries
    • z/OS
    • DB2
    • Application Development
    • IMS
    • Network
    • Security
    • Education Documents
    • Inquire about a class
  • Schedule
  • Training/Program Paths
  • Services
  • C\TREK™
    • What Is C\TREK™?
    • C\TREK™ Beta Program
    • C\TREK™ Screens & Videos
  • Company
    • About Us
    • Contact Us
    • Join Mailing /Career
  • More
    • Home
    • Education
      • CICS
      • MQSeries
      • z/OS
      • DB2
      • Application Development
      • IMS
      • Network
      • Security
      • Education Documents
      • Inquire about a class
    • Schedule
    • Training/Program Paths
    • Services
    • C\TREK™
      • What Is C\TREK™?
      • C\TREK™ Beta Program
      • C\TREK™ Screens & Videos
    • Company
      • About Us
      • Contact Us
      • Join Mailing /Career

973.299.9669

  • Sign In
  • Create Account

  • My Account
  • Signed in as:

  • filler@godaddy.com


  • My Account
  • Sign out

Signed in as:

filler@godaddy.com

  • Home
  • Education
    • CICS
    • MQSeries
    • z/OS
    • DB2
    • Application Development
    • IMS
    • Network
    • Security
    • Education Documents
    • Inquire about a class
  • Schedule
  • Training/Program Paths
  • Services
  • C\TREK™
    • What Is C\TREK™?
    • C\TREK™ Beta Program
    • C\TREK™ Screens & Videos
  • Company
    • About Us
    • Contact Us
    • Join Mailing /Career

Account


  • My Account
  • Sign out


  • Sign In
  • My Account
ZCubed Technologies

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 

Dates & Enrollment

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 

Dates & Enrollment

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

Dates & Enrollments

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

Dates & Enrollments

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  

Dates & Enrollments

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  

Dates & Enrollments

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  

Dates & Enrollment

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  

Dates & Enrollment

Copyright © 2025 ZCubed Technologies - All Rights Reserved.

  • Education Documents
  • Inquire about a class
  • Schedule
  • CICS WallChart
  • About Us
  • Join Mailing /Career
  • Student Portal

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept