Know DB2

Db2 12 for z/OS - Database Administration

From Start to Finish Part 2

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

Topics Covered:

Duration: 5 Day Hands - on Labs.

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

Prerequisites: An understanding of the relational data model and SQL.

Db2 12 for z/OS Database Administration

Part 2 Class Outline:

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 and Storage Management
  • Db2 and RACF
  • Attachment Facilities
  • Data Structure Management
  • Commands & Utilities Overview
  • Data Access
  • The Logical to Physical Transition Process
  • Workshop
  •  

Database Structures - Part 1

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

Database Structures - Part 2 Data Access & Data Integrity

  • Indexes
  • Workshop
  • Data Integrity
  • -Referential Integrity
  • -Constraint Rules
  • -UDTs & UDFs & Views
  • -Triggers
  • The Db2 Catalog Details
  • -Tables and uses
  • -Developing useful Catalog SQL
  • Workshop
  •  

Loading & Managing Db2 Databases

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

Operational Utilities

  • RUNSTATS Utility
  • Analyzing Statistics
  • REORG Utility
  • Workshop
  •  

Database Backup & Recovery Details

  • Backup & Recovery Procedures
  • Full vs. Incremental Copies
  • Utilities:
  • -COPY
  • -QUIESCE
  • -RECOVER
  • -MERGECOPY
  • -REPORT
  • -MODIFY
  • UNLOAD utility
  • -Functionality, Syntax
  • -Unloading from table spaces
  • -Unloading from copy datasets
  • -Samples
  • CopyToCopy
  • -Functionality
  • -Syntax
  • -Samples
  • Cross Loader
  • -Functionality, EXEC SQL
  • -LOAD INCURSOR, Samples
  • Dynamic Utility Jobs
  • -Overview
  • -LISTDEF
  • -TEMPLATE
  • -OPTIONS
  • -Samples
  • Workshop
  •  

Db2 System Restart / Recovery Details

  • How Db2 Startup/Shutdown works
  • Understanding Allied Agents
  • The subsystem: DBM, IRLM, SSA, DDF
  • BSDS. 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
  •  

Class Summary and Review

  • ©2021 Computer Business International, Inc.

Would you like to schedule or customize this class?
Please call our toll free number (866-224-4968) or email us at info@cbi4you.com.