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:

5 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:


  • Course Code:


Who should attend & recommended skills:

Database administrators or system administrators with basic experience & basic DB2 for Z/OS administration

Who should attend & recommended skills

  • Database Administrators or System Administrators who will be working with Db2 for z/OS Database Administrators: Basic to Intermediate (1-5 years’ experience) or System Administrators: Basic to Intermediate (1-5 years’ experience) DB2 for Z/OS Administration: Basic (1-2 years’ experience)

About this course

Advanced Database Administration is an in-depth systems look at Db2 for z/OS course. In this course you are introduced to the Systems side of Db2, monitoring, performance issues, system backup and recovery, and planning the installation or migration of Db2. Attend this course prior to installing or migrating to Db2.

Skills acquired & topics covered

  • System Performance and Tuning
  • System Backup and Recovery Options
  • Planning for Migration and Installation
  • Installation and Migration

Course breakdown / modules

  • 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?

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

  • Utilities Enhancements
  • New Packaging, Versioning Considerations
  • BACKUP System/RESTORE System
  • Copy Pools
  • What to set up
  • Options
  • Syntax of BACKUP and RESTORE
  • Review Utilities – Changes in Db2 12
  • COPY and System Pages
  • Rebalancing Partitions
  • DPSI Support
  • Stand – alone Utilities
  • Workshop and Lab

  • Architecture review

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

  • Media from IBM
  • Distribution Libraries
  • Target Libraries
  • SMP/E
  • Walk through the tasks
  • VSAM catalog and alias
  • System data sets and database

  • Initialize system datasets and databases
  • Function levels in Db2 12
  • Workshop and Lab

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

  • 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
  • Workshop and Lab

  • 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
  • Single Phase Migration Process
  • New Sample Jobs
  • Optional Job streams
  • CICS considerations
  • Workshop and Lab
  • Summary