Know Db2

Db2 Version 8 to Version 10 for z/OS Skip Level Migration

This workshop reviews the migration changes that the DBA and System Adminstrator will need to know for migrating from Db2 Version 8 to Db2 10 for z/OS.

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

Audience: Anyone who will be working on the migration ot Db2 10 for z/OS from Version 8 of Db2 z/OS including database adminstrators and system administrators.

Db2 Version 8 to Version 10 for z/OS Skip Migration 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 V8 to Db2 10 migration
  • 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
  •  
  •  
  • ©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.