Know DB2

Db2 12 for z/OS - Database Administration

From Start to Finish: Part: 3

Db2 Database Administration Part 3 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.

Topics Covered:

Duration: 5-Day Lecture, Workshops, Labs

Audience: All personnel who will be working with Db2 for z/OS as DBA’s or System Administrators

Db2 12 for z/OS Database Administration

Part 3 Class Outline:

System Performance and Tuning

  • What's New?
  • Traces available in Db2
  • What are IFCID’s
  • SMF Statistics
  • What are the default trace classes?
  • Cost 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?
  • - How does parallelism affect usage?
  • - DSNDB07 Work Files
  • Sizing
  • What they are used for
  • Db2 Products – Performance Monitoring
  • Vendor Products for Monitoring
  • Workshop and Lab
  •  

BACKUP System / RESTORE System

  • Utilities Enhancements
  • New Packaging, Versioning Considerations
  • BACKUP System/RESTORE System
  • - CopyPools
  • - What to set up
  • - Options
  • - Syntax of BACKUP and RESTORE
  • 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
  •  

Network Computing, Data Sharing Review

  • Architecture review
  •  

Enhancements Overview

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

What IBM Sends You

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

Performance & Availability

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

Installation & Migration Review

  • Installation Changes
  • Release incompatibilities Review
  • Walking through the Task List
  • Prerequisites
  • Getting Ready, Things to Do
  • Early Code Considerations
  • Fallback
  • Key Checks before you Migrate / Install
  • Catalog Changes
  • -New Table Spaces
  • -New Tables & New Indexes
  • Workshop and Lab
  •  

Installation, Migration & Fallback Process

  • Prepare z/OS
  • DSNZPARMs - zParms
  • - Review of all parameters in zParms
  • - What changed
  • On-Line z-Parm’s
  • - 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
  •  
  •  
  • ©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.