Db2 12 for z/OS -
Migration and Installation

This workshop examines the migration and installation changes System Administrators and Database Administrators will need to know for Db2 12 for z/OS.
Duration: 3 Days - Hands-on Labs/Remote Access
Audience: Anyone who will be working on the migration or installation of Db2 12 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.
For scheduling information please call our toll free number at 1.866.224.4968 or visit our website at cbi4you.com
Db2 12 for z/OS - Migration and Installation
Class Outline:
Installation and Migration
- • Premigration requirements
- • Hardware Synergy
- • Software requirements
- • z/OS and CPU requirements
- • Extended RBA/LRSN format
- • zEnterprise Data Compression
- • DFSMS storage tiers
- • Auxiliary storage
- • Prerequisites Planning
- • Migration without SYSADM
- • Migration and Catalog
- • Maintenance required
- • Enabling APARs
- • Fallback SPE
- • ERLY code
- • Release Incompatibilities
- • Single Phase migration process
- • Installation Changes
- - Modified/new installation jobs
- • Enhancements in Installation
- • Panel Changes and impact
- • DSNZPARM
- - Changed/removed/depreciated
- • Modified installation jobs
- • Processes changed in Db2 12
- •IFCIDs changes to know
- •Review & Labs
System Operation and Maintenance Data Structures
- • Continous delivery
- • Activation of a Function Level
- • Function levels 501, 500, 100
- • Return to previous function level
- • Code Level
- • RBA/LRSN Log size
- • BSDS conversion
- • Changes to Catalog and Directory
- • Minimum Catalog level
- • DISPLAY GROUP command
- • Review and Labs
Utility and Command Changes to Know
- • Impact on Utilities
- • DISPLAY UTILITY output
- • REORG
- - DSMAX - open data sets
- - Mapping 16 TB to 4 PB
- - UTS - PBR RPN
- - Pageset - Pagenum
- - Compression dictionaries
- - Reducing the need for REORG
- - On-Line REORG changes
- - Reduction of SWITCH impact
- - Mapping Table
- - Without SORT of data
- - REBALANCE improvements
- • RUNSTATS
- - Enhancements for SQL
- • DRDA Fast Load
- • LOAD Enhancements
- • REPAIR utility
- • RTS statistics externalize
Utility and Command Changes to Know: (continued)
- • 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
- • In-Memory contiguous Buffer Pools
- • Buffer Pool size limit
- • Optimizer enhancements
- • With/without In Memory feature
- • Active log datasets >4G
- • Identifying critical statistics
- • RELEASE(DEALLOCATE)
- • Range Partitioned Table Space changes
- • Data Sharing Improvements
- • DDF thread improvements
- • MERGE Enhancements
- • Review & Labs
Availability
- • DROP COLUMN changes
- • CANCEL DDF Thread changes
- • TRANSFER OWNERSHIP
- • SQL interruption changes
- • Adaptive Index
- • Fast Traversal Block for Indexes (FTB)
- • Idle thread break-in
- • Work File Enhancements
- • Application Compatibility
- • APPLCOMPAT support
- • Data Sharing enhancements
- • 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
- To Schedule this class call 1.866.224.4968
- © 2019 Computer Business International, Inc.