Know Db2

Db2 11 for z/OS - Migration and Installation for the DBA and Systems Administrator

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

Duration:3 Days-Lecture Only

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, SPUFI and / or Data Studio.

Db2 11 for z/OS – Migration and Installation for the DBA and Systems Administrator

Class Outline:

Installation and Migration

  • Hardware Synergy
  • z/OS and CPU requirements
  • Conversion of BSDS
  • Extended RBA/LRSN formats
  • 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
  • -Optional Program Requirements
  • Migration Paths and Versions
  • Premigration requirements
  • Maintenance required
  • Release Incompatibilities
  • -Application & SQL
  • -Utilities
  • -Commands
  • Installation Changes
  • -Modified /new installation jobs
  • -EDM calculations
  • Enhancements in Installation
  • DSNZPARM
  • -Changed / removed / depreciated
  • Log Writing efficiencies
  • Modified installation jobs
  • Processes changed in DB2 11
  • IFCIDs changes to know
  • Review & Labs
  •  

System Operation and 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
  • DISPL
  • Compression dictionaries Change Data Capture
  • CANCEL DDF Thread changesxx
  • SQL interruption changes
  • Global Variable support
  • Continuous Block Fetching
  • Review & Labs
  •  

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

Utility and Command Changes to Know: (continued)

  • RUNSTATS
  • - USE PROFILE for LISTDEF
  • - RESET ACCESSSPATH
  • 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 & Labs
  •  

Backup and Recovery

  • Removal of PIT recovery restrictions
  • RESTORE SYSTEM VCAT name
  • SYSLGRNX for Catalog/Directory
  • REORG & COPY incompatibilities
  • Enhancements to BACKUP SYSTEM
  • Review & Labs
  •  

Performance and Tuning

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

Availability

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

Security and Auditing

  • Column masking function changes
  • UNION column access control
  • GROUP BY access control removal
  • DISTINCT aggregate function
  • Exit authorization enhancements
  • Program authorization enhancements
  • 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.