Coding Db2 Applications for Performance Expert Videos Series

In these expert videos, a breakdown of what constitutes performance in relation to Db2 applications is discussed. The presenter begins with a high-level view of performance, and the factors to be considered when coding, and managing Db2 applications.

These expert videos delve deeper into the relational aspect of Db2 databases, explaining how it impacts the way applications are coded. The presenter discusses traditional data processing techniques and describes how this process differs when coding for Db2 databases. A range of coding tips are presented that will improve the performance of your Db2 applications.

These expert videos focus on the benefits of using indexes when accessing data through SQL. It begins by looking at using SQL to obtain only the data required, and minimizing the passes through that data. You will see how indexes can improve SQL performance and also where indexes cannot be used. Finally, you will see how the way that Db2 data is stored can also impact performance when accessing it.

These expert videos look at concurrency, how it works, and the performance benefits it can provide. You will see how Db2 table spaces, tables, pages, and rows can be locked and when each of these types of locks should be considered for use. Details on isolation levels, how they are specified, and the impact they have on your SQL program is also presented. A section on common concurrency problems including lock suspensions, timeouts, and deadlocks is covered, and how they can be avoided. You will also see how parallelism is enabled and how it is used to improve processing efficiency.

These expert videos begin by reviewing the role of the Db2 Optimizer and how it is used to satisfy SQL requests. You will then explore the various options for accessing data in a single table, and then take a look at the methods that Db2 can use to combine data when more than one table is accessed in your SQL code. Focus will then turn to filter factors, describing what they are, how you can calculate them for your data and queries, and how Db2 uses them to estimate the amount of data that it needs to access. Finally, methods that you can use to examine the access paths chosen by Db2 for your SQL queries will be discussed.

These expert videos provide some tips and techniques for coding efficient SQL statements in your Db2 applications. You will discover several different ways to avoid writing code, for example by using existing Functions and Db2 Utilities, and see how reusable Db2 code in the form of stored procedures and triggers, can be created. You will also look at the use of dynamic and static SQL and when each should be used, and how to use set operations in Db2 to combine data from multiple queries in different ways and for different use cases. Finally, you will be introduced to general tips and techniques for writing SQL statements.