Db2 Advanced SQL with Performance and Tuning For Programmers

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.

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

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.


Copyright © 2017 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media