Know Db2

Db2 10 for z/OS Migration and Installation

Db2 10 Migration and Installation workshop examines the migration and installation changes System Administrators and Database Administrators will need to know for Db2 10 for z/OS.

Duration: 3 Days-Hands-on Labs/Remote Access

Audience: Anyone who will be working on the migration or installation of Db2 10 for z/OS including database administrators and system administrators.

Prerequisites: Working knowledge of previous Db2 versions on z/OS, TSO, SPUFI and / or Data Studio.

Db2 10 for z/OS – Migration and Installation

Class Outline:

Installation and Migration

  • System Structure Changes
  • Db2 Components / Resource Managers
  • Address Spaces, Work Request in DB2
  • Attachment Facilities
  • Storage-Real / Auxiliary
  • Shared Virtual Memory
  • Page Size and Hardware
  • Migration and Install differences
  • V10 Products and Features
  • Release incompatibilities
  • Preplanning & Prerequisites
  • Db2 V9 to Db2 10 migration
  • Installation / Migration process
  • DSNZPARM changes
  • Identifying additional service environments
  • Catalog and Directory changes
  • DBM1 Storage changes
  • DSNZPARM planning
  • Methods and Applying Maintenance
  • Enhancements to the Installation
  • Processes in Db2 10
  • Review & Labs
  •  

System Operation and Maintenance Data Structures

  • Temporal tables
  • Temporal Data – System & Business
  • Enhancement to UTS’s
  • WorkFile Enhancements
  • Hash Table Access
  • Locking
  • Safe query optimization
  • Dealing with uncertainty
  • RID List failures
  • Review & Labs
  •  

Utility and Command Changes to Know

  • REORG catalog options
  • RUNSTATS
  • LOAD/UNLOAD
  • Key Db2 Commands
  • - Uses, Authorization, Output
  • -BIND QUERY
  • -FREE QUERY
  • -MODIFY DDF
  • IFCIDs New & Changed
  • Review & Labs
  •  

Backup and Recovery

  • System Requirements
  • System level backup and recovery procedures
  • REPORT and MODIFY Utility
  • BACKUP / RESTORE SYSTEM
  • Db2 Disaster Recovery process
  • Db2 Data Sharing Recovery
  • Scenarios
  • Review & Labs
  •  

Performance and Tuning

  • Review analyzing performance
  • Tracing in Db2 changes
  • Buffer Pools and performance
  • -Thresholds / Ratios
  • -Page Management
  • -Statistics
  • Sort Pool, Work Files
  • EDM Pool, RID Pool
  • Efficient use of memory
  • Workload manager settings for DB2
  • Autonomic vs. Manual Statistics
  • Stand - alone and Diagnostic Utilities
  • Space Issues and Log Issues
  • WLM and Stored Procedures
  • Review & Labs
  •  

REBIND Requirements

  • Use of RELEASE (DEALLOCATE) Early evaluation of residual predicates
  • IN-list improvements (new access method)
  • SQL pagination (new access method)
  • Query parallelism improvements
  • Index include columns
  • Predicate evaluation enhancements
  • EXPLAIN table changes
  • RID list overflow improvements
  • Enhancements to Native SQL Procedures
  • High Performance DBATs
  • Review & Labs
  •  

Security and Auditing

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

Class Summary

  • ©2017 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.