Know Db2

Db2 11 for z/OS -
Enhancements for the DBA & System Administrator

Db2 11 for z/OS installation and migration planning for the DBA and System Administrator.

Topics Covered:

Duration: 2 Days, Lecture, Hands-on remote labs

Labs: Using TSO, ISPF, SPUFI

Audience: Anyone who will be installing or migrating to Db2 11 for z/OS, lead programmers, database administrators and system administrators.

Prerequisites: Working knowledge of basic SQL, TSO, and SPUFI.

Db2 11 for z/OS - Enhancements for the DBA & System Administrator

Class Outline:

Prerequisite Planning

  • Maintenance on Db2 10
  • DSNZPARM Changes
  • IFCID use for planning
  • Extended Log Record Issues
  • Extended Log Record Enhancements
  • BSDS Conversion
  • 3rd Party Product
  • Db2 Connect Concerns
  • Security Enhancements
  • Workshop
  •  

In-Memory Enhancements

  • Sparse Index enhancements
  • DSNZPARM control
  • Memory management
  • Estimating zIIP savings
  • High Performance DBATs
  • Sort Limit Support
  • IFCIDs to use
  • Workshop
  •  

Efficiency Enhancements

  • CPU savings and performance
  • Data Compression
  • Disk Space Allocation
  • Index Skipping
  • DISTINCT – Early Out
  • Using CACHE
  • Workshop
  •  

Performance Enhancements

  • Empty PBG Partitions
  • DDF Threads New Options
  • CANCEL THREAD FORCE
  • Partition Limit Key
  • Sort work files
  • DGTTs
  • No Log
  • RIDs and Workfile Usage
  • Table space scans
  • Number of Open Datasets
  • XML Improvements
  • Workshop
  •  

Optimizer Externalization/Input Enhancements

  • Missing statistics/Collection
  • SYSIBM.SYSSTATFEEDBACK
  • Virtual Indexes
  • RTS Statistics Externalization
  • Override predicate selectivity
  • Archive Transparency
  • Temporal Auditing
  • Temporal Support on Views
  • Temporal Special Registers
  • Workshop
  •  

Utilities and Command Changes

  • Automatic Pseudo Delete
  • DSNZPARM support
  • CANCEL THREAD FORCE
  • zIIP eligibility
  • NULL & Indexes & Indirect References
  • EXCLUDE NULL KEYS
  • PCTFREE FOR UPDATE
  • PCTFREE_UPD
  • Buffer Pools
  • Get Page Classification
  • Random vs. Sequential
  • Workshop
  •  

Performance Enhancements

  • Empty PBG Partitions
  • DROP column
  • DDF Threads New Options
  • CANCEL THREAD FORCE
  • No Log Declared Temps
  • Partition Limit Key
  • Sort work files
  • -DGTTs / No Log
  • RIDs and Workfile Usage
  • Table space scans
  • Number of Open Datasets
  • XML Improvements
  • Screening Enhancements
  • DPSIs Enhancements
  • Partition Elimination on Join
  • ACCESS DATABASE command performance
  • Workshop
  • No log DGTTs
  • Temporal registers
  • Workshop
  •  

Class Summary

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