Know DB2

Db2 for z/OS - Database Administration Bootcamp

 

Database Administration Bootcamp is a 5-day advanced course that provides the attendee with the skill sets required to understand physical database designs, perform database implementations and to maintain Db2 for z/OS databases in an on-going production environment.

Topics Covered:

Duration: 5 Day Hands - on Labs.

Audience: Db2 Database Administrators, Data Administrators and Systems Administrators who will be designing, implementing and/or maintaining Db2 for z/OS.

Prerequisites: An understanding of the relational data model, basic z/OS structure, JCL and SQL.

Db2 for z/OS Database Administration Bootcamp Class Outline:

 

Db2 and the Environment

  • Db2 Structural Overview
  • Db2 and Mainframes
  • Address Spaces
  • - Systems Services
  • - Database Services
  • - IRLM
  • - Distributed Data Facility
  • - Stored Procedures
  • Db2 Data Sharing Overview
  • Db2 and Storage Management
  • Db2 and RACF
  • Attachment Facilities
  • Data Structure Management
  • Commands & Utilities Overview
  • Data Access
  • The Logical to Physical Transition Process
  • Workshop
  •  

Databases and Storage Management

  • Table spaces
  • Workshop
  • Table Design
  • Column Design
  • Workshop
  •  

Data Access & Data Integrity

  • Indexes
  • Workshop
  • Data Integrity
  • - Referential Integrity
  • - Constraint Rules
  • - UDTs & UDFs & Views
  • - Triggers
  • The Db2 Catalog Details
  • - Tables and uses
  • - Developing useful Catalog SQL
  • Workshop
  •  

Loading & Managing Db2 Databases

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

Operational Utilities

  • RUNSTATS Utility
  • Analyzing Statistics
  • REORG Utility
  • Workshop
  •  

Database Backup & Recovery Details

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

Db2 System Restart - Recovery Details

  • How Db2 Startup - Shutdown works
  • 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 utilites and Service Aids
  • Workshop
  •  

System Peformance and Tuning

  • What's New?
  • Traces available in Db2
  • What are IFCID's
  • SMF Statistics
  • What are the default trace classes?
  • What classes are running in Db2
  • What do I trace and why?
  •  

System Peformance and Tuning cont.

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

BACKUP System - RESTORE System

  • Utilities Enhancements
  • New Packaging, Versioning Considerations
  • BACKUP System - RESTORE System
  • - Copy Pools
  • - What to set up - Options
  • - Syntax of BACKUP and RESTORE
  • - Workshop and Labs
  •  

Review Utilites - Changes in Db2

  • 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 through the tasks
  • VSAM catalog and alias
  • System data sets and databases
  • Initialize system datasets and databases
  • Function levels in Db2
  • Workshop and Lab
  •  

Performance and Availability

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

Installation and Migration Review

  • Installation Changes
  • Release incompatibilities Review
  • Prerequisites
  • Getting Ready, Things to do
  • Early Cody Considerations
  • Fallback
  • Key Checks before you Migrate / Install
  • Catalog Changes
  • - New Table Spaces
  • - New Tables and New Indexes
  • Workshop and Lab
  •  

Installation, Migration and Fallback Process

  • 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 Incompatibilites 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
  •  
  •  
  •  
  • © Computer Business International, Inc.

Would you like to schedule or customize this class?
Please call our toll free number 1.866.224.4968 or email us at info@cbi4you.com.