SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

z/OS and DB2 Training


I really liked the fact that we could follow using the manual PDF files on our individual machines. This allowed to easily/quickly scroll back/forth the slides without having to interrupt the class to ask to go back to certain slides when needing to review something. This also allowed to easily search within the manual for specific keywords while doing exercises
Comment from Mitel

1. Title

  • The Complete DB2 Performance Tuning Course for z/OS on Mainframe (DB2PERF, 4 days)
    View PDF

2. Course Pre-requisites

  • Good knowledge of the z/OS operating system. Good mainframe knowledge.

3. Target Audience

  • IT Professionals who want to perform effective performance tuning in a z/OS environment

4. Dates and Pricing


2 People for Guaranteed Live or Virtual Delivery $3,900.00 per person

5. Outline

Module 1: About DB2

Topic 1: Overview of DB2 Functions and Architecture

Topic 2: About the Subsystem and Application functions

Topic 3: About Operations and Performance

Topic 4: About IBM zEnterprise System, System z and z/OS

Topic 5: DFSMS Storage Tiers

Topic 6: Additional Enhancements

Topic 7: Using Compression

Module 2: Exploring Scalability

Topic 1: Working with Extended RBA and LRSN

Topic 2: Using NOT LOGGED with Declared Global Temporary Tables

Topic 3: More Open Data Sets (DSMAX)

Topic 4: About PBG Mapping Tables

Module 3: Exploring Availability

Topic 1: Exploring Online Schema Changes

Topic 2: About Recovery Options

Topic 3: Automatic Index Recovery from GRECP or LPL status

Topic 4: About Improved Availability when Altering Limit Keys

Topic 5: Exploring Work File Database Enhancements

Topic 6: About Parallel Processing of Utilities

Topic 7: Compression Dictionary Availability for CDC Tables

Topic 8: Exploring DROP Column Support

Topic 9: Enhancements for Defer define object

Topic 10: Break-In of Persistent Threads and BIND, REBIND, and DDL

Topic 11: Idle Thread Break-In

Module 4: Data Sharing

Topic 1: The Group Buffer Pool Write-Around Protocol

Topic 2: Improved CASTOUT Processing

Topic 3: Improved DELETE_NAME Performance

Topic 4: Restart light with CASTOUT

Topic 5: About Locking

Topic 6: Index Availability and Performance

Topic 7: Group Buffer Pool Performance

Topic 8: Automatic LPL Recovery

Topic 9: Log Record Sequence Number Spin Avoidance

Module 5: SQL

Topic 1: Introduction to SQL on DB2

Topic 2: Working with Global Variables

Topic 3: Working with Array Data Type

Topic 4: Aliases for SEQUENCES

Topic 5: New Built-In Functions

Topic 6: Working with SET CURRENT APPLICATION COMPATIBILITY

Topic 7: Working with Temporal Special Registers

Topic 8: Working with CUBE, ROLLUP and GROUPING SETS

Topic 9: Working with ALTER TABLE DROP COLUMN

Topic 10: Working with LIKE_BLANK_INSIGNIFICANT DSNZPARM

Module 6: Application Integration

Topic 1: Ensuring Application Compatibility

Topic 2: Transparent Archiving of Temporal Data

Topic 3: Providing Support for Big Data

Topic 4: Using the Scoring Adapter

Topic 5: Using JavaScript Object Notation

Topic 6: Suppressing Null Indexes

Module 7: XML

Topic 1: XML Technologies Overview

Topic 2: XQuery Support

Topic 3: XML Performance

Topic 4: XQuery FLWOR Expressions

Topic 5: Working with XMLTABLE

Module 8: Connectivity and Administration

Topic 1: About Client Information

Topic 2: Cancel Thread and Cancel SQL Statement

Topic 3: Continuous Block Fetching

Topic 4: Support for Global Variables

Topic 5: Local Stored Procedure Execution

Topic 6: Multi-threaded Java Stored Procedure Environment

Topic 7: ADMIN_COMMAND_MVS Stored Procedure

Topic 8: Drivers, Clients, and Connectivity Requirements

Module 9: Utilities

Topic 1: Online REORG enhancements

Topic 2: Running Statistics

Topic 3: Backup and Recovery

Topic 4: LOAD and UNLOAD

Topic 5: Compression Dictionaries for Change Data Capture

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette