Signed in as:
filler@godaddy.com
Db2 for z/OS: Recovery [DDR]
OVERVIEW
This course provides attendees with a comprehensive introduction to the recovery of Db2 objects. The course examines all the provided Db2 utilities and service aids and discusses their involvement in recovery scenarios involving user data and Db2 data such as the catalog and directory.
COURSE DURATION & PRICE
2 Days
Hands-On
Private-Only
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- Db2 Physical Data Storage
- Db2 Logging
- Introduction to Db2 Utilities
- Utilities for Data Integrity
- Utilities for Backup & Recovery
- Other Online Utilities
- Stand-Alone Utilities (service aids)
- Catalog & Directory Recovery
COURSE OBJECTIVES
- Describe the structure and format of Db2 pagesets
- List all of the major recovery components
- Describe the need for Db2 logging to assist in recovery situations
- Describe the need for and use of all Db2 utilities
- Identify when service aids may be required for use in recovery situations
- Describe the additional considerations when recovering catalog and directory tablespaces
PREREQUISITES
While in-depth knowledge of Db2 is not required, a basic understanding of relational databases is assumed. Familiarity with TSO/ISPF and JCL is also required.
Email at Info@zcubedtech.com to find out more
Db2 for z/OS: Operations [DOPS]
OVERVIEW
This course provides attendees with a comprehensive introduction to the operation of Db2 for z/OS systems. The course examines normal start-up, operation, and shutdown of the Db2 system, plus the additional steps that may be required following an abnormal termination. The need for deferred and conditional restarts is discussed, as are the methods of setting these up, and evaluating any additional work that may be required following the use of these methods. The diagnosis and resolution of other problems that may occur are also discussed, such as out of sync. Log files, out of space datasets, and read/write errors on recovery datasets.
COURSE DURATION & PRICE
1 Day
Hands-On
Private-Only
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- Db2 Overview
- Db2 System & Operations
- Db2 Logging
- Abnormal Termination & Restart
- Problem Analysis and Handling
COURSE OBJECTIVES
- Describe the actions taken during normal start-up, operation, and shut-down of the Db2 system
- Explain the actions to take during start-up following an abnormal termination
- Understand the need for deferred restart, how it is controlled, and the effect it will have on the Db2 system and data
- Explain the need for conditional restart, how it is controlled, and the effect it will have on the Db2 system and data
- Analyze any outstanding work following a conditional or deferred restart, and take the actions required to complete it
- Interpret common error messages, and decide upon the actions required
PREREQUISITES
While in-depth knowledge of Db2 is not required, a basic understanding of relational databases would be beneficial. Familiarity with TSO/ISPF, JCL and operations in a z/OS environment is assumed.
Email at Info@zcubedtech.com to find out more
Db2 for z/OS: Operations & Recovery [DRR]
OVERVIEW
A comprehensive introduction to the recovery of Db2 objects and the processes involved. The course examines all the provided Db2 utilities and service aids and discusses their involvement in recovery scenarios. Start-up, operation, and shut-down of the Db2 system is fully covered, to ensure attendees appreciate the additional steps that may be required following an abnormal termination. The need for deferred and conditional restarts is discussed, as are the methods of setting these up, and evaluating any additional work that may be required following the use of these methods. The diagnosis and resolution of other problems that may occur are discussed, such as out of sync. log files, out of space datasets, and read/write errors on recovery datasets
COURSE DURATION & PRICE
3 Days
Hands-On
$2400
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- DB2 Overview
- DB2 System & Operations
- DB2 Logging
- Abnormal Termination & Restart
- Problem Resolution
- DB2 Physical Data Storage
- Introduction to DB2 Utilities
- Utilities for Data Integrity
- Utilities for Backup & Recovery
- Other Online Utilities
- Stand-Alone Utilities (service aids)
- Catalog & Directory Recovery
COURSE OBJECTIVES
- List all of the major recovery components use the Db2 utilities and service aids that are used in recovery situations
- Describe the actions to take during normal start-up, operation, and shut-down of the Db2 system
- Explain the actions to take during start-up following an abnormal termination
- Understand the need for deferred restart, and the effect it will have on the DB2 system and data
- Explain the need for conditional restart and the effect it will have
- Set up a deferred or conditional restart
- Determine the effect conditional restart is likely to have upon data integrity
- Analyze any outstanding work following a conditional or deferred restart and take the actions required to complete it
- Interpret common error messages and decide upon the actions required
PREREQUISITES
While in-depth knowledge of Db2 is not required, a basic understanding of relational databases is assumed. Familiarity with TSO/ISPF is also required
Email at Info@zcubedtech.com to find out more
Db2 for z/OS: Intro for Tech Support and Operations [DBTS]
OVERVIEW
This course is specifically designed to provide a comprehensive introduction to Db2 for z/OS, covering all features. Taught from a Technical Support/Computer Operations perspective, this course introduces, describes, and explains the fundamental principles of Db2 for z/OS. Additionally, the course explains relational theory and concepts and demonstrates how Db2 adheres to them. The course also covers Db2 data storage, the Db2 system and its operation, Structured Query Language, the use of Db2 Interactive (Db2i), and the management of Db2 data using standard utility tasks.
COURSE DURATION & PRICE
3 Days
Hands-On
$2400
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- DBMS Overview
- Relational Theory & Concepts
- DB2 System & Operations
- Introduction to SQL
- Physical Database Design & Data Definition Language
- DB2 Monitoring & Control
- DB2 Logging
- Managing Data with DB2 Utilities - Overview
- DB2 Shutdown, Startup & Recovery
- Program Preparation & Execution
COURSE OBJECTIVES
- Describe the relational concepts and theory, and the advantages of a RDBMS
- Describe the components of the DB2 system, their function, and how they are controlled
- Identify the objects used to store DB2 data and the relationships between them
- Code the SQL statements needed to create and modify DB2 data objects, and control access to them
- Code SQL statements to read and modify DB2 data and interrogate the DB2 catalog
- Describe and fully utilize all the functions available with DB2 Interactive (DB2I)
- Understand the role of logging in DB2 system and data recovery
- Use online utilities to backup and restore data, and perform other data management tasks
- Describe the use of stand-alone utilities and identify situations where they may be required.
- Describe and use various DB2 commands to control and monitor the DB2 environment and objects
- Describe the actions taken during normal start-up, operation, and shut-down of the DB2 system
- Explain the actions to take during start-up following an abnormal termination
- Describe the steps involved in program preparation and the purpose of the DB2 pre-compiler and bind processes
PREREQUISITES
The course is particularly suitable for Technical Support and Operations personnel working in a Db2 for z/OS environment and for trainee DBAs. For software developers and analysts, we recommend the course Db2 for z/OS: Introduction, Concepts & Facilities [DC].
Email at Info@zcubedtech.com to find out more
DB2 for z/OS: Database Design, Implement & Admin [DDA]
OVERVIEW
This course is designed for DB2 DBAs to learn essential skills for database administration. The course covers effective database design, implementation, and support. The instructor explains the entire database design process, from logical database modeling to physical database implementation. The class fully explores and demonstrates system architecture, operational facilities, and utilities used in a DB2 for z/OS environment. Additionally, the course covers monitoring, security, and recovery techniques
COURSE DURATION & PRICE
3 Days
Hands-On
$3350
Email at Info@zcubedtech.com to find out more
COURSE SYNOPSIS
- DBMS Overview
- Relational Theory & Concepts
- Table Design
- Introduction to SQL
- DB2 Index Usage & Design
- Physical Database Design & Data Definition Language
- DB2 Locking & Concurrency
- DB2 EXPLAIN
- DB2 System Architecture
- DB2 Pagesets
- DB2 Security & Data Control Language
- Managing Data with DB2 Utilities - Overview
- Online Data Utilities
- Online Recovery Utilities
- Stand-alone Utilities
- Performance Tuning
COURSE OBJECTIVES
- Describe the internal structure and components of DB2 UDB for z/OS databases
- Design & assess a logical database model
- Design & 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 & implement an effective locking strategy & use DB2 commands & other facilities to monitor locking for performance
- Use EXPLAIN to evaluate the effectiveness of the database design
- Describe the DB2 environment, and understand the use of key DB2 components such as buffer pools, the DB2 catalog & directory, logging data sets, etc.
- Describe the internal structure of DB2 UDB for z/OS databases
- Understand & assess security & related requirements
- Use DB2 commands to monitor & control DB2 objects, processes & operations
- Understand & use the full complement of DB2 online data, recovery utilities & the DB2 stand-alone utilities
- Use DB2 traces to record performance monitoring information
- Understand & interpret information in DB2PM accounting and statistics reports
PREREQUISITES
Attendees should be familiar with the DB2 environment and have knowledge of SQL or have attended the DB2 concepts and SQL courses
Email at Info@zcubedtech.com to find out more
Copyright © 2025 ZCubed Technologies - All Rights Reserved.