Db2 Advanced SQL with Performance and Tuning For Programmers

Catalog Home IBM Mainframe, Midrange & ISV Products Db2 for z/OS
Your Training Location:  

Db2 Advanced SQL with Performance and Tuning For Programmers

  Add Course To Watch List
  View Full Course Outline
  Request A Public Course
         In Your Area

  Request A Quote For A
        Private Class

Delivery Options & Status:
Instructor Led
Loading Course Dates...
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
ViewHide Additional Dates

This course focuses on best practices for proper design, coding and maintenance techniques with the primary objective of improving Db2 performance. Students will learn specific factors which impact performance and how they can proactively address performance issues in their SQL and application programs. Students will learn the features of the EXPLAIN function, how it is used for optimization and how optimization hints can change the optimizer’s decisions. Participants will understand the purpose and function of the PLAN TABLE. This course includes features up to and including version 10 of Db2 for z/OS.

Before attending this course, students should have experience coding in one of the programming languages listed: COBOL, PL/I or C, TSO/ISPF and Db2 file structures.

3 Days/Lecture & Lab

This course is designed for application programmers and programmer/analysts who will be using SQL statements in a high level programming language to manipulate Db2 tables.

  • Application Tuning
  • SQL Statements That Can Affect Performance
  • EXPLAIN Function
  • Simple and Complex Access Paths
  • Index Structure, Design, and Usage
  • Db2 Buffer Pools and Their Impact on Performance

< >

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media