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: Advanced Database Administration [ADBA]

OVERVIEW

This course builds upon the skills taught in the course Db2 for z/OS: Database Administration [DDAN]. It provides attendees with an understanding of additional and advanced administration tasks. It also examines in-depth a number of the subjects covered by the earlier course 

COURSE DURATION & PRICE

3 Days

Hands-On

$2,550

Email at Info@zcubedtech.com  to find out more of db2 database administration training, db2 performance training & db2 training

Dates & Enrollment

COURSE SYNOPSIS

  • On-line Schema Enhancements & Versioning
  • Partition Management
  • Distinct Data Types
  • User-defined Functions
  • Stored Procedures
  • Triggers
  • Large Object & XML Data Types
  • Specialized Table Types
  • Row & Column Level Access Control

COURSE OBJECTIVES

  • Appreciate the latest on-line schema enhancements.
  • Understand the concept and usage of versioning and pending definition changes
  • Appreciate the enhanced facilities to manage partitioned data
  • Identify the need for and definition of distinct data types, user-defined functions, triggers and stored procedures
  • Describe how large object and XML data is defined and held
  • Understand the concept and use of in-line LOB data
  • Understand the recovery implications of LOB and XML data
  • Appreciate the need for and use of specialized table types including materialized query, clone, temporal and archive tables
  • Understand how row and column level security may be achieved using multi-level security, row permissions and column masks.

PREREQUISITES

An understanding of the Db2 relational database management system and database administration tasks in general. This can be gained by attending the DB2 for z/OS: Database Administration [DDAN] & Db2 for z/OS: Database Design, Implementation & Administration [DDA]

Email at Info@zcubedtech.com  to find out more

Dates & Enrollment

Db2 for z/OS: Systems Administration [DSA]

OVERVIEW

This course is the definitive Db2 systems administration course. It comprises all the information required to understand and manage Db2 system functions. It describes & explains the installation and tailoring of the Db2 system and its attachments, system security, problem determination, system recovery and performance issues 

COURSE DURATION & PRICE

4 Days

Hands-On

$3,150

Email at Info@zcubedtech.com or Find out more

DATES & ENROLLMENTS

COURSE SYNOPSIS

  • Db2 System Architecture
  • Db2 System Installation & Migration 
  • Db2 System Installation & Migration Overview
  • Db2 System Migration & Modification 
  • Connecting to Db2
  • Db2 Security Administration
  • Db2 Logging
  • Db2 Data Recovery
  • Db2 Shutdown Recovery
  • Db2 Monitoring & Control
  • Problem Determination
  • Performance Overview

COURSE OBJECTIVES

  • Describe the address space structure and components of a Db2 subsystem
  • Understand the Db2 installation process
  • Identify Db2 functions that best suit the requirements of their site
  • Implement security for the Db2 system
  • Understand and implement Db2 system and data recovery and restart procedures
  • Understand the control and use Db2 trace information to perform system and application tuning
  • Understand the basic problem determination tools 

PREREQUISITES

A working knowledge of TSO/ISPF and a basic understanding of SQL and Db2 objects (databases, tables, indexes, etc.) used in Db2 systems 

Email at Info@zcubedtech.com or Find out more

DATES & ENROLLMENTS

Db2 for z/OS: Database Design & Implementation [DDD]

OVERVIEW

This course provides a detailed explanation of the methodology to be followed in order to design and implement efficient Db2 for z/OS databases. The course discusses all aspects of database design from the logical data model and implementation of the physical design, through to ongoing performance monitoring of the resultant database. 

COURSE DURATION & PRICE

2 Days

Hands-On

$1,450

Email at Info@zcubedtech.com or Find out more

DATES & ENROLLMENTS

COURSE SYNOPSIS

  • DBMS Overview
  • Relational Theory & Concepts
  • Table Design
  • Db2 Index Usage & Design
  • Physical Database Design & Data Definition Language
  • Db2 Locking & Concurrency
  • Db2 EXPLAIN

COURSE OBJECTIVES

  • Describe the internal structure and components of Db2 for z/OS databases
  • Design and assess a logical database model
  • Design and implement efficient physical databases from the logical model using relevant options to create and amend storage groups, databases, table spaces, tables, indexes, aliases, synonyms, etc.
  • Understand and implement an effective locking strategy and use Db2 commands and other facilities to monitor locking for performance
  • Use EXPLAIN to evaluate the effectiveness of the database design

PREREQUISITES

Attendees should be familiar with the Db2 environment and have knowledge of SQL or have attended RSM's courses DC - Db2 for z/OS: Introduction, Concepts & Facilities and DSQL - Understanding and Using SQL.

Email at Info@zcubedtech.com or Find out more

DATES & ENROLLMENTS

Db2 for z/OS: Monitoring & Tuning Appl Performance [DPTA]

OVERVIEW

This course examines and explains the critical factors that affect Db2 for z/OS performance. The teaching of the effective use of monitoring and tuning tools is an integral part of all tuning topics throughout the course 

COURSE DURATION

3 Days 

Hands-On

$2,500

Email at Info@zcubedtech.com  to find out more

DATES & ENROLLMENTS

COURSE SYNOPSIS

  • Performance Overview
  • Db2 Traces
  • Db2 Optimizer Access Path Selection
  • Db2 EXPLAIN 
  • Database Design Factors
  • Application Design Factors
  • Locking and Concurrency
  • Application Programs versus Db2 Utilities
  • Monitoring Application Performance
  • Performance Analysis

COURSE OBJECTIVES

  • Plan for application monitoring and tuning.
  • Identify database design factors that affect performance.
  • Identify application design factors that affect performance.
  • Use EXPLAIN as a first step towards performance tuning.
  • Use Db2 traces to identify problem areas and identify tuning opportunities 

PREREQUISITES

A sound understanding of Db2 and z/OS concepts is required 

Email at Info@zcubedtech.com  to find out more

DATES & ENROLLMENTS

Db2 for z/OS: Monitoring & Tuning Systems Performance [DPTS]

OVERVIEW

This course examines and explains the critical factors that affect Db2 for z/OS from a systems perspective. The effective use of monitoring and tuning tools is an integral part of all tuning topics throughout the course 

COURSE DURATION & PRICE

2 Days

Hands-On

$1,650

Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

COURSE SYNOPSIS

  • Performance Overview
  • Db2 Traces 
  • Performance Monitoring 
  • Db2 System Parameters 
  • Tuning Buffer Pools
  • Tuning the EDM Pool
  • Tuning the Sort Pool
  • Tuning the RID Pool
  • Monitoring Application Performance
  • Tuning Threads
  • Tuning Locking & Concurrency
  • Tuning Data-Sharing

COURSE OBJECTIVES

  • Identify the Db2 and MVS factors that affect performance 
  • Plan for Db2 subsystem monitoring and tuning
  • Detect poor performance using various techniques 
  • Identify tuning opportunities 
  • Carry out effective problem detection through the use of an established performance and monitoring policy 
  • Implement and interpret Db2 related trace outputs covering I/O tuning, buffer pool tuning, EDM pool tuning, IRLM tuning, thread tuning 

PREREQUISITES

A sound understanding of Db2 and z/OS concepts is required 

Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

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