Db2 12 for z/OS SQL Performance and Tuning Training

Name: Db2 12 for z/OS SQL Performance and Tuning Training
Brand: Microtek Learning
Price: $2495
Rating: 4.6 (173 reviews)

Course Description

Db2 12 for z/OS SQL Performance and Tuning Training is aimed at professionals to teach them the leading methodologies to prevent SQL performance problems. This technical course contains the best practices to enhance the performance of existing SQL. Our enterprise training program is ideal for organizations and companies. It helps professionals gain a better understanding of indexes and improves their index designing abilities.

In this course, you will learn the best methods to optimize multi-table access and figure out how to operate with the optimizer. This program is suitable for Db2 for z/ OS DBA and DBA 12 for Z/OS application developers and individuals whose work revolves around SQL Performance. This technical training program helps you operate with subqueries and teaches you to utilize accounting traces and other tools to spot performance issues in existing SQL.

Prerequisites for this training

Familiarity with SQL, Db2 12 for z/OS, and application programming

DB2 Family Fundamentals

Who should attend this course?

The training is intended for Db2 12 for z/OS app developers. However, the primary audience for this training are Db2 12 for z/OS DBAs or professionals working in SQL tuning and performance in for z/OS environment.

Schedules

Jun 21, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Jul 19, 2023

9:30 am - 5:30 pm EST

Online

ENROLL NOW

Aug 16, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

What you will learn

Designing and understanding better indexing.
Figure out working with optimizer such as providing guidance and avoiding pitfalls.
Optimizing multi-table authorizations.
Working with sub-queries.
Avoiding lock difficulties.
Utilize account tracing along with another tool and locating performance issues in pre-existing SQL.

Curriculum

Module 1: Introduction to SQL performance and tuning

Performance issues

Simple example

Visualizing the problem

Summary

Module 2: Performance analysis tools

Components of response time

Time estimates with VQUBE3

SQL EXPLAIN

The accounting trace

The bubble chart

Performance thresholds

Module 3: Index basics

Indexes

Index structure

Estimating index I/Os

Clustering index

Index page splits

Module 4: Access paths

Classification

Matching versus Screening

Variations

Hash access

Prefetch

Caveat

Module 5: More on indexes

Include index

Index on expression

Random index

Partitioned and partitioning, NPSI and DPSI

Page range screening

Features and limitations

Module 6: Tuning methodology and index cost

Methodology

Index cost: Disk space

Index cost: Maintenance

Utilities and indexes

Modifying and creating indexes

Avoiding sorts

Module 7: Index design

Approach

Designing indexes

Module 8: Advanced access paths

Prefetch

List prefetch

Multiple index access

Runtime adaptive index

Module 9: Multiple table access

Join methods

Join types

Designing indexes for joins

Predicting table order

Module 10: Subqueries

Correlated subqueries

Non-correlated subqueries

ORDER BY and FETCH FIRST with subqueries

Global query optimization

Virtual tables

Explain for subqueries

Module 12: Set operations

UNION, EXCEPT, and INTERSECT

Rules

More about the set operators

UNION ALL performance improvements

Module 13: Table design

Number of tables

Clustering sequence

Denormalization

Materialized query tables (MQTs)

Temporal tables

Archive enabled tables

Module 14: Working with the optimizer

Indexable versus non-indexable predicates

Boolean versus non-Boolean predicates

Stage 1 versus stage 2

Filter factors

Helping the optimizer

Pagination

Module 15: Locking issues

The ACID test

Reasons for serialization

Serialization mechanisms

Transaction locking

Lock promotion, escalation, and avoidance

Module 16: More locking issues

Skip locked data

Currently committed data

Optimistic locking

Hot spots

Application design

Analyzing lock waits

Module 17: Massive batch

Batch performance issues

Buffer pool operations

Improving performance

Benefit analysis

Massive deletes

With Microtek Learning, you’ll receive:

Certified Instructor-led training
Industry Best Trainers
Official Training Course Student Handbook
Pre and Post assessments/evaluations
Collaboration with classmates (not available for a self-paced course)
Real-world knowledge activities and scenarios
Exam scheduling support*
Learn and earn program*
Practice Tests
Knowledge acquisition and exam-oriented
Interactive online course.
Support from an approved expert
For Government and Private pricing*

* For more details call: +1-800-961-0337 or Email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.