Microtek Learning Logo

Db2 12 for z/OS SQL Performance and Tuning Training

4.6
(4.6)

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.

  • Category : IBM

Course Price : $2495 Per Participant

enroll Now Enroll Now calendar Check Schedule

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. 

Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

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

Prerequisites

  • 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

Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.

For dates, times, and location customization of this course, get in touch with us.

You can also speak with a learning consultant by calling 800-961-0337.

Curriculum

  • Performance issues
  • Simple example
  • Visualizing the problem
  • Summary
  • Components of response time
  • Time estimates with VQUBE3
  • SQL EXPLAIN
  • The accounting trace
  • The bubble chart
  • Performance thresholds
  • Indexes
  • Index structure
  • Estimating index I/Os
  • Clustering index
  • Index page splits
  • Classification
  • Matching versus Screening
  • Variations
  • Hash access
  • Prefetch
  • Caveat
  • Include index
  • Index on expression
  • Random index
  • Partitioned and partitioning, NPSI and DPSI
  • Page range screening
  • Features and limitations
  • Methodology
  • Index cost: Disk space
  • Index cost: Maintenance
  • Utilities and indexes
  • Modifying and creating indexes
  • Avoiding sorts
  • Approach
  • Designing indexes
  • Prefetch
  • List prefetch
  • Multiple index access
  • Runtime adaptive index
  • Join methods
  • Join types
  • Designing indexes for joins
  • Predicting table order
  • Correlated subqueries
  • Non-correlated subqueries
  • ORDER BY and FETCH FIRST with subqueries
  • Global query optimization
  • Virtual tables
  • Explain for subqueries
  • UNION, EXCEPT, and INTERSECT
  • Rules
  • More about the set operators
  • UNION ALL performance improvements
  • Number of tables
  • Clustering sequence
  • Denormalization
  • Materialized query tables (MQTs)
  • Temporal tables
  • Archive enabled tables
  • Indexable versus non-indexable predicates
  • Boolean versus non-Boolean predicates
  • Stage 1 versus stage 2
  • Filter factors
  • Helping the optimizer
  • Pagination
  • The ACID test
  • Reasons for serialization
  • Serialization mechanisms
  • Transaction locking
  • Lock promotion, escalation, and avoidance
  • Skip locked data
  • Currently committed data
  • Optimistic locking
  • Hot spots
  • Application design
  • Analyzing lock waits
  • Batch performance issues
  • Buffer pool operations
  • Improving performance
  • Benefit analysis
  • Massive deletes

    • Course Details

    • enroll enroll-green
      Enrolled: 1632
    • duration duration green
      Duration: 3 Days
    ENROLL NOW

    Talk to Learning Advisor