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.
Audience
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.
Topics
There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a DB2 Advanced SQL with Performance and Tuning For Programmers class.
There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a DB2 Advanced SQL with Performance and Tuning For Programmers class.
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.
There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a DB2 Advanced SQL with Performance and Tuning For Programmers class.