We are a family owned USA based Corporate Training Company determined to help professionals, teams, and organizations improve.

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.

banner-img
Home » Database » Db2 for z/OS Intermediate Database Administration

Course Skill Level:

Intermediate

Course Duration:

5 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:

    Database

  • Course Code:

    DB2IDAN22J02

Who should attend & recommended skills:

Administrators with basic relational data model & SQL experience

Who should attend & recommended skills

  • Db2 Database Administrators, Data Administrators and Systems Administrators who will be designing, implementing and/or maintaining Db2 12 for z/OS
  • Relational data model: Basic (1-2 years’ experience)
  • SQL: Basic (1-2 years’ experience)

About this course

Intermediate Database Administration 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.

Skills acquired & topics covered

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

Course breakdown / modules

  • 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

  • Table Spaces
  • Workshop
  • Table Design
  • Column Design
  • Workshop

  • 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

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

  • RUNSTATS Utility
  • Analyzing Statistics
  • REORG Utility
  • Workshop

  • 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
  • Copy-To-Copy
    • Functionality
    • Syntax
    • Samples
  • Cross Loader
    • Functionality, EXEC SQL
    • LOAD INCURSOR, Samples
  • Dynamic Utility Jobs
    • Overview
    • LISTDEF
    • TEMPLATE
    • OPTIONS
    • Samples
  • Workshop

  • How Db2 Startup/Shutdown works
  • Understanding Allied Agents
  • Understanding Allied Agents
  • 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

Browse our programs to take the next step toward advancing yourself, your team, and organization.

Browse Courses