Know Db2

Db2 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 Database Administration

Part 3 Class Outline:

System Performance and Tuning

  • What's New?
  • Traces available in Db2
  • -Accounting
  • -Performance
  • -Exception
  • -Global Trace
  • 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?
  • How do I tune Buffer Pools?
  • -What are the dependencies?
  • -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 / New Features
  • -UNLOAD / LOAD
  • -COPY and System Pages
  • -Sliding Secondary Quantity
  • -REORG, MODIFY, REPAIR
  • -Rebalancing Partitions
  • -RUNSTATS
  • -DPSI Support
  • -DSN1COPY
  • Stand - alone Utilities
  •  

Network Computing, Data Sharing Review

  • Architecture review
  •  

Enhancements Overview

  • What's New?
  • Db2 Packaging
  • Unicode in Db2
  • What’s Available from IBM?
  •  

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
  •  

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
  • Key Checks before you Migrate / Install
  • Catalog Changes
  • -New Table Spaces
  • -New Tables & New Indexes
  • -SYSOBDS
  • -What’s not converted to UNICODE?
  • -DFSORT
  •  

Installation, Migration & Fallback Process

  • Prepare z/OS
  • zPARM’s
  • -Review of all parameters in zParms
  • -What changed
  • On-Line z-Parm’s
  • -What panels and what parameters
  • -Migration Job Steps Reviewed
  • -Installation CLIST
  • Prepare z/OS TSO Environment for Install CLIST
  • Provide parameters for Install CLIST
  • -Libraries, data set naming conventions
  • Executing the Install CLIST
  • -Compatibility Mode(CM)
  • Walk thru the jobs
  • -Enable New Function Mode(ENFM)
  • Walk thru the jobs
  • -New Function Mode(NFM)
  • Walk thru the jobs
  • -BSDS Size Increases
  • -New Sample Jobs)
  • -Optional Job streams
  • -CICS considerations
  • Release Incompatibilities Review
  • Review of Db2 Security Checking
  • IFCID’s to Know About
  • 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.