zOS & DB2 Training: Mainframe Performance Tuning for z/OS


Course Delivery

Live Instructor-Led Training

Course Description

The course Mainframe Performance Tuning for z/OS (zOS & DB2 Training) is an exploration of DB2 administration from concepts to data use & configuration. The training includes configuration related to availability, scalability & connectivity. You learn about SQL syntax, data sharing & integration and XML. This DB2 course also discusses utilities and a few useful tips & tricks.

Course Dates and Pricing


Nov 27 - 30, 2018$3,500.00Jan 8 - 11, 2019$3,500.00Feb 5 - 8, 2019$3,500.00Mar 5 - 8, 2019$3,500.00Apr 2 - 5, 2019$3,500.00

Course 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

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related z/OS and DB2 Training

zOS & DB2 Training: Exploring Mainframe Programming

The course Exploring Mainframe Programming (zOS & DB2 Training) is an introduction to mainframe programming in z/OS. The training includes a general discussion on application architecture in a mainframe environment and covers available mainframe programming languages including Assembler, COBOL, C/C++, CLIST, REXX & more. The course proceeds with an overview of common mainframe programming tasks followed by an exploration of compilation & link editing. Training course titled zOS & DB2 Training: Exploring Mainframe Programming that will allow you to hone your professional skills.

Nov 20 - 23, 2018$3,500.00Dec 18 - 21, 2018$3,500.00Jan 29 - Feb 1, 2019$3,500.00Feb 26 - Mar 1, 2019$3,500.00Mar 26 - 29, 2019$3,500.00Apr 23 - 26, 2019$3,500.00

zOS & DB2 Training: The Complete DB2 Administration Course

The course The Complete DB2 Administration Course (zOS & DB2 Training) is an exploration of performance tuning & scalability with DB2. The training includes non-partitioned & multi-partitioned databases, tablespaces, buffer pools and database objects. This DB2 course also discusses backup & recovery, availability, security & event monitoring & connectivity. Your skillset is completed with a focused activity on performance tuning & troubleshooting. Training course titled zOS & DB2 Training: The Complete DB2 Administration Course that will allow you to hone your professional skills.

Dec 11 - 14, 2018$3,500.00Jan 22 - 25, 2019$3,500.00Feb 19 - 22, 2019$3,500.00Mar 19 - 22, 2019$3,500.00Apr 15 - 18, 2019$3,500.00

zOS & DB2 Training: z/OS & Mainframe Introduction

The course z/OS & Mainframe Introduction (zOS & DB2 Training) is an exploration of the modern mainframe. Beginning with an introduction to the Mainframe, the training covers z/OS architecture & basics, data set creation & use, JCL programming, batch processing and the Job-Entry subsystem. Training course titled zOS & DB2 Training: z/OS & Mainframe Introduction that will allow you to hone your professional skills.

Nov 27 - 30, 2018$3,500.00Jan 8 - 11, 2019$3,500.00Feb 5 - 8, 2019$3,500.00Mar 5 - 8, 2019$3,500.00Apr 2 - 5, 2019$3,500.00