Know Db2

Db2 12 for z/OS - Migration and Installation

Db2 12 Migration and Installation 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.

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

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

Utility and Command Changes to Know: (continued)

  • RUNSTATS
  • - Enhancements for SQL
  • DRDA Fast Load
  • LOAD Enhancements
  • 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

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