Know Db2

Db2 11 for z/OS – Migration and Installation Class

DETAIL COURSE OUTLINE - 1/2 Day Classes

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

Duration: 4 days, 1/2 day sessions, Instructor led, LECTURE ONLY, Virtual Class.

Format: 4 - ½ Day Lecture's.

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

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

Db2 11 for z/OS – Migration and Installation Class Outline:

Installation and Migration – Part I

  •  
  • Hardware Synergy
  • z/OS and CPU requirements
  • Conversion of BSDS
  • Extended RBA/LRSN format
  • Using 1 MB page frames
  • Using zIIP processors
  • zEnterprise Data Compression
  • DFSMS storage tiers
  • Auxiliary Storage
  • AUTOSIZE options VPSIZEMIN, VPSIZEMAX
  • Prerequisites Planning
  • Processors
  • Storage
  • Operational Planning
  • Optional Program Requirements
  • Migration Paths and Versions
  • Pre-migration requirements
  • Maintenance Requirements
  • Release Incompatibilities
  • Application and SQL Changes
  • Utility Changes
  • Commands Changed
  • Review
  • Auxiliary Storage
  • End of 1/2 day - Day 1.
  •  
  •  

Installation and Migration – Part II

  •  
  • Installation Changes
  • -Modified/new installation jobs
  • -EDM Calculations
  • Enhancements in installation
  • DSNZPARMs-Changed / removed / depreciated
  • Log Writing efficiencies
  • Modified installation jobs
  • Processes changed in Db2 11
  • IFCIDs changes to know
  • Review
  •  
  •  

System Operation / Maintenance / Data Structures

  •  
  • RBA and LRSN extended format
  • BSDS conversion
  • Changes to Catalog and Directory
  • Impact on Utilities
  • DSMAX - open data sets
  • Mapping up to 16 TB tables
  • DISPLAY UTILITY output
  • Compression Dictionaries
  • Change Data Capture
  • CANCEL DDF Thread changes
  • SQL interruption changes
  • Global Variable support
  • Continuous Block Fetching
  • Review
  • End of 1/2 day - Day 2
  •  
  •  

Utility and Command Changes to Know

  •  
  • REORG
  • Reducing the need for REORG
  • On-Line REORG changes
  • Reduction of SWITCH impact
  • Mapping Table
  • Without SORT of data
  • REBALANCE improvements
  • RUNSTATS
  • USE PROFILE for LISTDEF
  • RESET ACCESSPATH
  • Cross-loader additional support for XML
  • NPSIs offload to zIIP
  • LOAD SHRLEVEL
  • NONE with PARALLEL
  • CHANGE with PARALLEL
  • REPAIR utility
  • RTS statistics externalize
  • DSN1COPY changes
  • DSNACCOX
  • Review
  •  

Backup and Recovery

  • Removal of PIT recovery restrictions
  • RESTORE SYSTEM VCAT name
  • SYSLGRNX for Catalog/Directory
  • REORG & COPY incompatibilities
  • Enhancements to BACKUP SYSTEM
  • Review
  • End of 1/2 day - Day 3
  •  

Performance and Tuning

  • Optimizer enhancements
  • Identifying critical statistics
  • RELEASE (DEALLOCATE)
  • Pseudo-deleted Indexes
  • Data Sharing Improvements
  • DDF thread improvements
  • Review
  •  

Availability

  • DROP COLUMN changes
  • Idle thread break-in
  • Work File Enhancements
  • Application Coompatibility
  • Data Sharing enhancements
  • pureXML expansions
  • IDAA, Hadoop, Big Data Support
  • Review
  •  

Security and Auditing

  • Column masking function changes
  • UNION column access control
  • GROUP BY access control removal
  • DISTINCT aggregate function
  • Exit authorization enhancements
  • Program authrization enhancements
  • Review
  • End of 1/2 day - Day 4
  •  
  • ©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.