Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

Loading Events

Db2 z/OS Database Administration Bootcamp

  • $ 1850

  • Enroll now
  • Course Dates: 9/12/2022Course Duration: 5 DAYS
  • Course Category: Mainframe DatabaseCourse Code: DB2z/OSDBAdminJ22N02

Course Objectives

  • Db2 and the System Environment
  • Data Structures and Design
  • Database Design Implementation
  • Operations and Recovery

Outline

1 – Db2 and the Environment

  • Db2 Structural Overview
  • Db2 and Mainframes
  • Address Spaces
  • Systems Services
  • Database Services
  • IRLM
  • Distributed Data Facility
  • Stored Procedures
  • Db2 Data Sharing Overview
  • Db2 Storage Management
  • Db2 and RACF
  • Attachment Facilities
  • Data Structure Management
  • Commands and Utilities Overview
  • Data Access
  • The Logical to Physical Transition Process
  • Workshop

2 – Database Structures Detail – Part 1

  • Databases and Storage Management
  • Table Spaces
  • Workshop
  • Table Design
  • Column Design
  • Workshop

3 – Database Structures Detail – Part 2

  • Data Access and Data Integrity
  • Indexes/Workshop
  • Data Integrity
  • Referential Integrity
  • Constraint Rules
  • UDTs and UDFs and Views
  • Triggers
  • The Db2 Catalog Details
  • Tables and Uses
  • Developing useful Catalog SQL
  • Workshop

4 – Loading and Managing Db2 Databases

  • Design Implementation
  • LOAD Utility
  • CHECK Utility
  • COPY Utility
  • Workshop

5 – Operational Utilities

  • RUNSTATS Utility
  • Analyzing Statistics
  • REORG Utility
  • Workshop

6 – Database Backup and Recovery Details

  • Backup & Recovery Procedures
  • Full vs. Incremental Copies
  • Utilities:
  • COPY
  • QUIESCE
  • RECOVER
  • MERGECOPY
  • REPORT

7 – Database Backup and Recovery Details (Continued)

  • MODIFY
  • UNLOAD utility
  • Functionality, Syntax
  • Unloading from table spaces
  • Unloading from copy datasets
  • Samples
  • Copy-To-Copy
  • Functionality
  • Syntax
  • Samples
  • Cross Loader
  • Functionality, EXEC SQL
  • LOAD INCURSOR, Samples
  • Dynamic Utility Jobs
  • Overview
  • LISTDEF
  • TEMPLATE
  • OPTIONS
  • Samples
  • Workshop

8 – Db2 System Restart / Recovery Details

  • How Db2 Startup/Shutdown works
  • Understanding Allied Agents
  • Understanding Allied Agents
  • Active Logs, Archive Logs
  • Physical DASD, storage issues
  • Abnormal Startup and Issues
  • How to Prepare for System Recovery
  • Jobs we develop
  • Disaster Recovery Scenarios
  • Steps in System Recovery
  • Order of recovery in Db2
  • Determining successful systems recovery
  • Determining what Data Recovery is required
  • Stand-alone utilities and Service Aids
  • Workshop

9 – System Performance and Tuning

  • What’s New?
  • Traces available in Db2
  • What are IFCID’s
  • SMF Statistics
  • What are the default trace classes?
  • Costs of Traces in Db2
  • What classes are running in Db2?
  • What do I trace and why?
  • Tune Buffer Pools?
  • What are the dependencies?
  • Contiguous buffer pools
  • What type of pages?
  • In-use/Updated/Available
  • What techniques for performance?
  • How do I determine the size?
  • What thresholds are there in buffer pools?
  • DWQT, VDWQT, etc.
  • What determines hit ratio?
  • How does prefetching impact buffer pools?
  • How do I obtain buffer pool statistics?

10 – System Performance and Tuning

  • DSNDB07 Work Files
  • Sizing
  • What they are used for
  • Db2 Products – Performance Monitoring
  • Vendor Products for Monitoring
  • Workshop and Labs

11 – BACKUP System / RESTORE System

  • Utilities Enhancements
  • New Packaging, Versioning Considerations
  • BACKUP System/RESTORE System
  • Copy Pools
  • What to set up/Options
  • Syntax of BACKUP and RESTORE
  • Workshop and Labs

12 – Review Utilities – Changes in Db2 12

  • UNLOAD / LOAD
  • COPY and System Pages
  • REORG, MODIFY, REPAIR
  • Rebalancing Partitions
  • RUNSTATS
  • DPSI Support
  • DSN1COPY
  • Stand – alone Utilities
  • Workshop and Lab

13 – Network Computing, Data Sharing Review

  • Architecture review

14 – Enhancements Overview

  • What’s new
  • Db2 Packaging
  • What’s Available from IBM?
  • Workshop and Lab

15 – What IBM Sends You

  • Media from IBM
  • Distribution Libraries
  • Target Libraries
  • SMP/E
  • Walk through the tasks
  • VSAM catalog and alias
  • System data sets and databases
  • Initialize system datasets and databases
  • Function levels in Db2 12
  • Workshop and Lab

16 – Performance and Availability

  • Db2 and z/OS
  • Online subsystem parameters
  • Log manager enhancements
  • Restart Enhancements
  • Workshop and Lab

17 – Installation and Migration Review

  • Installation Changes
  • Release incompatibilities Review
  • Prerequisites
  • Getting Ready, Things to Do
  • Early Code Considerations
  • Fallback
  • Key Checks before you Migrate / Install
  • Catalog Changes
  • New Table Spaces
  • New Tables and New Indexes

18 – Installation, Migration and Fallback Process

  • Prepare z/OS
  • DSNZPARMs – zParms
  • Review of all parameters in zParms
  • What Changed
  • On-Line zParms
  • What panels and what parameters
  • Migration with/without SYSADM
  • Migration Steps Reviewed
  • Release Incompatibilities Review
  • Installation CLIST
  • Prepare z/OS TSO Environment for Install CLIST
  • Provide parameters for Install CLIST
  • Libraries, data set naming conventions
  • Executing the Install CLIST
  • CATMAINT UPDATE (DSNTIJTC)
  • Single Phase Migration Process
  • ACTIVATE NEW FUNCTION or DSNTIJAF
  • New Sample Jobs
  • Optional Job streams
  • CICS considerations
  • Workshop and Lab
  • Summary

Course Content

Db2 z/OS Database Administration Bootcamp (5-Day Training Course)

Live Online Instructor Led Training

Database Administration Bootcamp is a 5-day advanced course that provides the attendee with the skill sets required to understand physical database designs, perform database implementations and to maintain Db2 for z/OS databases in an on-going production environment.

Course Dates: Monday 9.12.2022 – Friday 9.16.2022

Course Cost per Participant: $1850.00
Course Times: 9:30am EST – 4:30pm EST

Top 10 Training Outcomes

  1. Boost job satisfaction, morale, and motivation
  2. Streamline efficiencies in processes, and time saved
  3. Adopt new technologies and methods
  4. Catapult innovation in strategic and tactical execution
  5. Swifter decision making
  6. Reduce employee turnover
  7. Even the playing field within the organization
  8. Stay ahead of the competition
  9. Energize teamwork, collaboration, and engagement
  10. Ongoing training is a talent recruiting differentiator
  11. (Bonus Outcome) Saving IT team time, resources, budget

Who should attend

Db2 Database Administrators, Data Administrators and Systems Administrators who will be designing, implementing and/or maintaining Db2 12 for z/OS.

Prerequisites

Participants should have an understanding of the relational data model, basic z/OS structure, JCL and SQL.