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.


Course Skill Level:


Course Duration:

1 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:


  • Course Code:


Who should attend & recommended skills:

Those experienced in previous versions of Db2

Who should attend & recommended skills

  • Those seeking a comprehensive review of tasks, methods, and responsibilities of a Db2 12 for Z/OS system administrator.
  • Db2 – previous versions on z/OS, TSO, JCL, and SPUFI: Basic to Intermediate (1-5 years’ experience).

About this course

This one-day review crammer course guides students through the six sections that comprise an in-depth review of Db2 system administration responsibilities. Review questions and answers accompany each section of the lecture material. Students attending this crammer course will review tasks, methods, and responsibilities of a Db2 12 for z/OS system Administrator.

Skills acquired & topics covered

  • Db2 12 for z/OS Installation and Migration System Structure – Discussion of the Architecture
  • Security and Auditing Topics in Db2 12 for z/OS
  • System Operation and Maintenance Topics in Db2 12 for z/OS
  • Backup and Recovery Topics in Db2 12 for z/OS
  • Performance and Tuning Topics in Db2 12 z/OS
  • Troubleshooting Topics in Db2 12 for z/OS”

Course breakdown / modules

  • Db2 components and Resource Managers
  • Address Spaces, Work requests in DB2
  • Attachment Facilities
  • Storage-Real and Auxiliary
  • Shared Virtual Memory
  • Migration and Install differences What I need to know
  • Db2 12 Products and Features
  • Release incompatibilities
  • Preplanning Prerequisites
  • Db2 11 to Db2 12 migration
  • Installation/Migration process
  • Identifying additional service environments
  • Catalog and Directory changes
  • DBM1 Storage changes
  • DSNZPARM planning
  • Methods and Applying Maintenance in Db2
  • Rudimentary knowledge of SMP/E
  • Overview of the steps in applying maintenance in DB2
  • Enhancements to the Installation/Migration Process in DB2 12
  • Review Practice Questions

  • Protecting Db2 subsystem and resources
  • New system authorities
  • Support for Distributed identities
  • Connection Level security enforcement
  • Audit Tracing/Policies
  • Role-Based Security
  • Review Practice Questions

  • New reorg catalog options
  • Key Db2 Commands
  • Uses, Authorization, Output
  • Db2 12 Utilities Changes to Know
  • MVS Commands to Know
  • Monitor and control Db2 threads
  • Review Practice Questions

  • System Requirements
  • System level backup and recovery procedures
  • REPORT and MODIFY Utility
  • Commands
  • Db2 Disaster Recovery process
  • Db2 Data Sharing Recovery
  • Scenarios
  • Review Practice Questions

  • Analyzing performance
  • Tracing in Db2
  • Buffer Pools and performance
  • Thresholds/Ratios
  • Page Management
  • Statistics
  • Sort Pool, Work Files
  • EDM Pool, RID Pool
  • Efficient use of memory
  • DSNZPARMs and tuning
  • Workload manager settings for Db2
  • Autonomic vs. manual RUNSTATS
  • Review Practice Questions

  • Tuning Elements
  • Components and Processes
  • Problem Resolution Methods
  • Tools for Problem Resolution
  • Stand-alone and Diagnostic Utilities
  • Space Issues and Log Issues
  • WLM and Stored Procedures
  • Review Practice Questions
  • Class Summary