Db2 Migrations

The Power of Professional Solutions for Your Db2 Migration

Db2 12 for z/OS -
Migration and Installation

IBM Gold Consultant

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