Db2 for z/OS: Recovery [DDR]

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. 

2 Days

Hands-On

Private-Only

Email at Info@zcubedtech.com  to find out more

• 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

• 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 

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

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 

3 Days

Hands-On

$2400

Email at Info@zcubedtech.com  to find out more

• 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

• 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 

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

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

3 Days

Hands-On

$3350

Email at Info@zcubedtech.com  to find out more

• 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

• 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 

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