You are viewing

CV963G: DB2 11 for z/OS Application Performance and Tuning

HRD Corp Claimable

HRD Corp SBL-Khas Claimable

Home » IBM Data and Analytics Certification Training » CV963G: DB2 11 for z/OS Application Performance and Tuning

CV963G: DB2 11 for z/OS Application Performance and Tuning

Fees:

RM8,630.00

Course duration

5 days

Accredited by

Array
(
    [ID] => 9560
    [id] => 9560
    [title] => ibm
    [filename] => ibm.svg
    [filesize] => 161628
    [url] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
    [link] => https://trainocate.com.my/home/ibm/
    [alt] => IBM Training and Certification
    [author] => 1
    [description] => 
     => 
    [name] => ibm
    [status] => inherit
    [uploaded_to] => 9
    [date] => 2022-10-28 08:09:07
    [modified] => 2022-10-28 08:09:07
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 1000
    [height] => 500
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 75
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [medium-width] => 300
            [medium-height] => 150
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [medium_large-width] => 768
            [medium_large-height] => 384
            [large] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [large-width] => 1024
            [large-height] => 512
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [1536x1536-width] => 1000
            [1536x1536-height] => 500
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [2048x2048-width] => 1000
            [2048x2048-height] => 500
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [blog-large-width] => 544
            [blog-large-height] => 272
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [blog-medium-width] => 320
            [blog-medium-height] => 160
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [recent-posts-width] => 700
            [recent-posts-height] => 350
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-400-width] => 400
            [fusion-400-height] => 200
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-600-width] => 600
            [fusion-600-height] => 300
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-800-width] => 800
            [fusion-800-height] => 400
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-1200-width] => 1000
            [fusion-1200-height] => 500
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-full-width] => 800
            [portfolio-full-height] => 400
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-one-width] => 540
            [portfolio-one-height] => 270
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-two-width] => 460
            [portfolio-two-height] => 230
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-three-width] => 300
            [portfolio-three-height] => 150
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [woocommerce_thumbnail-width] => 500
            [woocommerce_thumbnail-height] => 250
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [woocommerce_single-width] => 700
            [woocommerce_single-height] => 350
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [woocommerce_gallery_thumbnail-width] => 300
            [woocommerce_gallery_thumbnail-height] => 150
        )

)

Home » IBM Data and Analytics Certification Training » CV963G: DB2 11 for z/OS Application Performance and Tuning

CV963G: DB2 11 for z/OS Application Performance and Tuning

Course duration:

5 days

Fees:

RM8,630.00

Accredited by:

Array
(
    [ID] => 9560
    [id] => 9560
    [title] => ibm
    [filename] => ibm.svg
    [filesize] => 161628
    [url] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
    [link] => https://trainocate.com.my/home/ibm/
    [alt] => IBM Training and Certification
    [author] => 1
    [description] => 
     => 
    [name] => ibm
    [status] => inherit
    [uploaded_to] => 9
    [date] => 2022-10-28 08:09:07
    [modified] => 2022-10-28 08:09:07
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 1000
    [height] => 500
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 75
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [medium-width] => 300
            [medium-height] => 150
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [medium_large-width] => 768
            [medium_large-height] => 384
            [large] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [large-width] => 1024
            [large-height] => 512
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [1536x1536-width] => 1000
            [1536x1536-height] => 500
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [2048x2048-width] => 1000
            [2048x2048-height] => 500
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [blog-large-width] => 544
            [blog-large-height] => 272
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [blog-medium-width] => 320
            [blog-medium-height] => 160
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [recent-posts-width] => 700
            [recent-posts-height] => 350
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-400-width] => 400
            [fusion-400-height] => 200
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-600-width] => 600
            [fusion-600-height] => 300
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-800-width] => 800
            [fusion-800-height] => 400
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [fusion-1200-width] => 1000
            [fusion-1200-height] => 500
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-full-width] => 800
            [portfolio-full-height] => 400
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-one-width] => 540
            [portfolio-one-height] => 270
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-two-width] => 460
            [portfolio-two-height] => 230
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-three-width] => 300
            [portfolio-three-height] => 150
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [woocommerce_thumbnail-width] => 500
            [woocommerce_thumbnail-height] => 250
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [woocommerce_single-width] => 700
            [woocommerce_single-height] => 350
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/09/ibm.svg
            [woocommerce_gallery_thumbnail-width] => 300
            [woocommerce_gallery_thumbnail-height] => 150
        )

)

Overview

This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.

Skills Covered

Design better indexes
Determine how to live with the optimizer (avoid pitfalls, help when necessary)
Avoid locking problems
Use accounting trace information to find significant performance problems in an operational application

Who Should Attend

This intermediate course is designed for DB2 for z/OS application developers, DB2 for z/OS DBAs, and anyone else who is responsible for application performance and tuning in a DB2 for z/OS environment.

Course Curriculum

Prerequisites

You should have:

Familiarity with DB2 for z/OS application programming and SQL.

Download Syllabus

Course Modules

Expand all Collapse all

Module 1: Introduction to Application Performance and Tuning

Module 2: List Common Causes of Application Performance Problems

Module 3: Evalutate Different Approaches for Detecting the Problems

Module 4: Describe Possible Solutions

Module 5: Performance Analysis Tools

Module 6: Understand Components of Local Response Time (LRT)

Module 7: Identify Touch Random (TR), Touch Sequential (TS), and Fetch (F) Time Costs

Module 8: Utilize VQUBE3 to Estimate Local Response Time (LRT)

Module 9: Locate Necessary Time Values in an Accounting Trace Report

Module 10: Draw and Interpret a Bubble Chart

Module 11: Towards Better Indexes

Module 12: Understand DB2 Index Structure and Usage

Module 13: Evalute the Cost of Creating a New Index or Modifying an Existing Index

Module 14: Design the Best Possible Index for a Single Table Query

Module 15: Describe Prefetch Operations and Multi-Index Access

Module 16: Multiple Table Access

Module 17: Identify Various Join Methods and Join Types

Module 18: Predict Table Join Order

Module 19: Design the Best Indexes for Joining Tables

Module 20: Optimmize Correlated and Non-Correlated Subqueries

Module 21: Utilize UNION, INTERSECT, and EXCEPT Operations

Module 22: Towards Better Tables

Module 23: Evaluate Clustering Alternatives

Module 24: Understand Basic Rules of Nomalization

Module 25: Consider Conditions for Denormalization

Module 26: Define Materialized Query Tables

Module 27: Learning to Live with the Optimizer

Module 28: Describe the Limitations Related to Dangerous Predicates

Module 29: Identify Situations when the Optimizer Needs Help with Filter Factor Estimates

Module 30: Massive Batch

Module 31: Detect Performance Problems with Massive Batch Jobs Make Batch Jobs Run Faster

Module 32: Locking Issues

Module 33: Describe DB2 Serialization

Module 34: Understand Transaction Locking

Module 35: Avoid Locking Problems in Application Design

Module 36: Course Summary

Module 37: Summarize the Topics Covered in this Course

Request More Information

Training Options

Intake: Available Upon Request

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM8,630.00Enroll Now

Exam: No associated exam

Intake: Available Upon Request

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM8,630.00Enroll Now

Exam: No associated exam

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions

Company

Customer Service

Principals

2023 Top 20 IT Training and Technical Company

HRD Corp Training Provider 2

2023 Top 20 IT Training and Technical Company

HRD Corp Training Provider 2

No. 1 IT Training Center & Provider in Malaysia

Trainocate is the new and exciting development of the 25-year old establishment – Global Knowledge. The name Trainocate is inspired from the term “Training Advocate” which resonates the feeling of continuous learning, something that each member of the Trainocate team carries with them. We are in the business of empowering work forces in the Asia-Pacific region by maximizing their capabilities through training and certification. This not only helps with improving work performance but also, explores untapped potential within each individual.

Located in KL Eco City and just next to Mid Valley City, Trainocate Malaysia is a HRD Corp Registered Training Provider and Authorized Training Partner for big tech companies such as AWS, Alibaba Cloud, Cisco, Dell EMC, Fortinet, Google Cloud, IBM, Microsoft, NetApp, Nutanix, Oracle, Splunk, Red Hat, Trend Micro, and VMware. We also provide a broad range of human capital development and people skills training to individuals and organizations under American Management Association (AMA).

Years of experience in IT Training Provider Industry equates to bettering ourselves to ensure we deliver only the best training programs to our loyal clients, both in technology and people skills.

© Copyright Trainocate 2024. All rights reserved. IT Training Provider Malaysia