The Complete DB2 Performance Tuning Course for z/OS on Mainframe
(DB2PERF, Live Instructor-Led Training, 4 days)


Dates and Pricing


Jan 9 to Jan 12, 2018$3,000/person Feb 6 to Feb 9, 2018$3,000/person Mar 6 to Mar 9, 2018$3,000/person

Outline

About DB2
Overview of DB2 Functions and Architecture
About the Subsystem and Application functions
About Operations and Performance
About IBM zEnterprise System, System z and z/OS
DFSMS Storage Tiers
Additional Enhancements
Using Compression
Exploring Scalability
Working with Extended RBA and LRSN
Using NOT LOGGED with Declared Global Temporary Tables
More Open Data Sets (DSMAX)
About PBG Mapping Tables
Exploring Availability
Exploring Online Schema Changes
About Recovery Options
Automatic Index Recovery from GRECP or LPL status
About Improved Availability when Altering Limit Keys
Exploring Work File Database Enhancements
About Parallel Processing of Utilities
Compression Dictionary Availability for CDC Tables
Exploring DROP Column Support
Enhancements for Defer define object
Break-In of Persistent Threads and BIND, REBIND, and DDL
Idle Thread Break-In
Data Sharing
The Group Buffer Pool Write-Around Protocol
Improved CASTOUT Processing
Improved DELETE_NAME Performance
Restart light with CASTOUT
About Locking
Index Availability and Performance
Group Buffer Pool Performance
Automatic LPL Recovery
Log Record Sequence Number Spin Avoidance
SQL
Introduction to SQL on DB2
Working with Global Variables
Working with Array Data Type
Aliases for SEQUENCES
New Built-In Functions
Working with SET CURRENT APPLICATION COMPATIBILITY
Working with Temporal Special Registers
Working with CUBE, ROLLUP and GROUPING SETS
Working with ALTER TABLE DROP COLUMN
Working with LIKE_BLANK_INSIGNIFICANT DSNZPARM
Application Integration
Ensuring Application Compatibility
Transparent Archiving of Temporal Data
Providing Support for Big Data
Using the Scoring Adapter
Using JavaScript Object Notation
Suppressing Null Indexes
XML
XML Technologies Overview
XQuery Support
XML Performance
XQuery FLWOR Expressions
Working with XMLTABLE
Connectivity and Administration
About Client Information
Cancel Thread and Cancel SQL Statement
Continuous Block Fetching
Support for Global Variables
Local Stored Procedure Execution
Multi-threaded Java Stored Procedure Environment
ADMIN_COMMAND_MVS Stored Procedure
Drivers, Clients, and Connectivity Requirements
Utilities
Online REORG enhancements
Running Statistics
Backup and Recovery
LOAD and UNLOAD
Compression Dictionaries for Change Data Capture