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

z/OS and DB2 Training

Great material that I can take back to the workplace. Good case and exercises. Monitor setup is good and easy to follow.
Comment from Giant Tiger

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 7: Working with Temporal Special Registers

Topic 8: Working with CUBE, ROLLUP and GROUPING SETS

Topic 9: Working with ALTER TABLE DROP COLUMN


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